Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

IF Statements

Resolved · Medium Priority · Version 2003

Reply Tue 3 Mar 2009, 16:05Delegate Chrissy said...

Chrissy has attended:
Access Intermediate course

IF Statements

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

For upcoming training course dates see: Pricing & availability

Reply Tue 3 Mar 2009, 16:44Trainer Rajeev said...

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 articles

· How To Use Tabs To Show Lots Of Related Data On One Form In Access
· How To Create Calculated Fields In Access 2010 Tables
· How To Successfully Design An Access Database For A Paying Client
· How To Change The Data Displayed In A Linked Field In An Access Table
· How To Use Concatenation In Access To Create A Custom Lookup

Please browse our web site to find out more about
microsoft access 2002 training and other Microsoft training courses.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips