<< 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
