IIF problem

mugman17

Registered User.
Local time
Today, 02:04
Joined
Nov 17, 2000
Messages
110
Can you use an OR in an IIF statement? For instance:

IIf (Location = "27" or "18", TotalMgt, TotalMgt2).

It doesn't appear to work whatever I try.
 
Try

IIf (Location = "27" or Location = "18", TotalMgt, TotalMgt2)
 

Users who are viewing this thread

Back
Top Bottom