IF Statements

Resolved · Medium Priority · Version 2003

Tue 3 Mar 2009, 16:05 Delegate 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.

Tue 3 Mar 2009, 16:44 Trainer 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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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