That could be pretty slick. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Posted At: Wednesday, May 07, 2008 2:51 PM Posted To: RB7-L Conversation: [BULK] [RBASE-L] - RE: IFLTEQ Subject: [BULK] [RBASE-L] - RE: IFLTEQ Importance: Low
<< What I could use is IFIN(list, truevalue, falsevalue) >> Please -- even better: IIF(Condition, Value1, Value2) let's you do: IIF(vMyVar IN (. . .), 'YES', 'NO') IIF(vMyVar >= .vSomething, .vMyVar, .vSomething) IIF(vMyVar IN (. . .) AND vMyVar >= .vSomething, .vMyVar, NULL) and so on. Any condition that could be accommodated in the standard IF/THEN would work. -- Larry
