Dirk Goldgar wrote:
"Bob Barrows" wrote in message
...

Impossible. The IIF() function requires 3 arguments and you've only
supplied 2.


Quite possible, actually. While the VBA IIf() function requires all 3
arguments, the JET SQL IIf() function does not. In a query, it's the
SQL version of the function that will be used, not the VBA function
of the same name.

Learn something new every day, I guess. I always assumed it was using the
VBA function and never realized there was a JetSQL version.

I assume it returns Null if the test expression fails and no false result is
supplied ...
--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"