if statements

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » IF Statements

IF Statements

resolvedResolved · Medium Priority · Version 2003

Chrissy has attended:
Access Intermediate course

IF Statements

When is it best to use an IF statement. In a query or a form.

RE: IF Statements

Dear Chrissy

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

I would personally suggest to do it in Form because that is what most of the users use. But having said that you can always do the If statement in a query and then create a form based on the query.

I think it depends on personal situations as well as preferences.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Tue 10 Mar 2009: Automatically marked as resolved.


 

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips


Server loaded in 0.09 secs.