Command IIF
Hi guys,
I want to have multiple condition into IIF command, is it possible ?.....What I want to do is when my total is less than zéro, print "Return" when the language is english and "Retour" when the language is french. The second command is when the total
is equal or higher to zéro then print "Purchase" for english or "Achat" when french. here is the two separte command:
IIF(Transact.bTotal<0,"Retour","Achat")
IIF(Transact.lSeconde,"Purchase","Achat")
Is anybody could give me the good command to put ?
Tkx
August 27th, 2011 9:28am
Sounds like the Switch function may be a good fit.
http://weblogs.sqlteam.com/joew/archive/2008/08/20/60693.aspx
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]
Free Windows Admin Tool Kit Click here and download it now
August 27th, 2011 10:53am