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

if statements

ResolvedVersion 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:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.32 secs.