Multiple IIF statements

Corey

Registered User.
Local time
Today, 01:12
Joined
Sep 14, 2005
Messages
35
I'm trying to compile a number of IIF statements.

I have 6 IIF statements, but would like to put them all in to one IIF statement.

Could anyone help me with this one?

OrderTrack: IIf([O_SRC_CD]="2005WMDT","Web","Phone")
OrderTrack: IIf([O_SRC_CD]="2005WMKE","Internet","Phone")
OrderTrack: IIf([O_SRC_CD]="DOGNET23","Web","Fax")
OrderTrack: IIf([O_SRC_CD]="CANTRY3J","Web","")
OrderTrack: IIf([O_SRC_CD]="MAMTWOSE","Web",",")
OrderTrack: IIf([O_SRC_CD]="2005W999","Web","Mail")

Thank you for your help and time

Corey
 
Try this

IIf([O_SRC_CD]="2005WMDT","Web",IIF([O_SRC_CD]="2005WMKE","Internet",IIF([O_SRC_CD]="DOGNET23","Web",IIF([O_SRC_CD]="CANTRY3J","WEB",iif([O_SRC_CD]="MAMTWOSE","WEB",IIF([O_SRC_CD]="2005W99","Web","Mail"))))))
 
How do you know if something should be Fax, Phone or Mail?

Take a look at the SWITCH function.
 

Users who are viewing this thread

Back
Top Bottom