Where oh where has my IIF function gone!!

[celticcastles]

Apoligies if this is in the wrong forum but I didn't know what category expressions were under.

Having just had to convert a database from 2000 to 2002 I have found that when I use the expression builder the IIF statement is simply not there!

I use this statement a lot, and it's not even listed under the help system in Microsoft Acccess.

Please help. By the way I am using Access 2002 on a network.

Thanks

 

[celticcastles]

Um?

Well it has decided to appear when I am using it in the forms, but I can't use it in the tables - for example under validation rule?

Very strange.

Anyway no matter.

Just one of the confusing things that Access does!