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 » Access

	98.1 % recommend us
	More live stats...

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

Training information:

Access

Resolved · Low Priority · Version 2003

Reply Thu 12 Mar 2009, 15:51Delegate Nicola said...

Nicola has attended:
Excel Advanced course
Access Intermediate course

Access

Can I do IF statements the same as in Excel or are they different?

For upcoming training course dates see: Pricing & availability

Reply Mon 16 Mar 2009, 17:28Trainer Rajeev said...

RE: Access

Dear Nicola

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

The structure of If statements in Excel and Access is the same i.e. =IF(Logical Test, Value if true, Value If False)

But for some strange reason Access likes to call it IIF instead of IF.

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

Access articles

· Microsoft Access 2007: New Features
· How To Understand Access As A Relational Database
· Mining For Data With Access
· Learn The Secrets Of Customising An Autonumber Primary Key In Access
· How To Use A Parameter Query In Access

Please browse our web site to find out more about
ms-access-course and other Microsoft training courses.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips