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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics