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

Hi Corey,

This can get really ugly, but you could do it like this...

OrderTrack: IIf([O_SRC_CD]="2005WMDT","Web",IIf([O_SRC_CD]="2005WMKE","Internet",IIf([O_SRC_CD]="DOGNET23","Web", IIf([O_SRC_CD]="CANTRY3J","Web","")))) etc. etc.

The tricky part is getting the number of parenthesis figured out right!!

The other option could be to create a function that will take care of this, then just have something like OrderTrack: OrderTrack([O_SRC_CD])

Good luck,

Mike



Mike
EchoVue.com