Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training uk - The IIf statement

microsoft access training uk - The IIf statement

ResolvedVersion Standard

Fri 11 Jan 2008, 16:09 Delegate Ian said...

Ian has attended:
Access Intermediate course

The IIf statement

Why does Mircosoft Access use IIf for If statements when Excel and other programming languages use if?

Wed 16 Jan 2008, 09:13 Trainer Pete said...

RE: The IIf statement

Hi Ian, Thank you for the post, I remember we had a little chuckle about this on the course, so I expected you to post it as a question; Silly answer; I really dont know, I have searched and googled but no answer, it might be that in the way that Excel uses 'D' functions to distinguish those that are used in Database operations so although it is a pure IF function Access developers used an extra I to distinguish it from normal IF functions found in Excel. Hope that helps, best regards Pete.

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

microsoft access training uk - The IIf statement

The IIf statement

RE: The IIf statement

Access articles

Access tip:

Splittng a database