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
