IIF

[Frances]

What is the immediate If in Access 2007? Why not just If? The other
functions such as SUM and COUNT are the same as in Excel.

Just curious!

 

[KC-Mass]

Hi Francis,

The IIF function in Access allows you to resolve a question in one line
like:
Description = IIF(Age > 30, "Old", "Young")
That means that you can use it in queries, controls, etc.
Access does have an IF function that is only available if you are writing
VBA Code.
It looks like :
IF age is > 30 then
Description = "Old"
Else
DEscription = "Young"
End If

To make things more confusing, Excel has an IIF function that is only
available in its VBA code.

Why the differences - They were brought along and developed for different
markets by different Microsoft groups. That said they are much more uniform
today then in the mid 90s.

Regards

Kevin

 

[dhstein]

Hi - what is the IIF in Excel VBA - and what is it for? Thanks.