FYI...DataColumn.Expression Property
IIF
Description Gets one of two values depending on the result of a logical expression.
Syntax
ArgumentsCode:IIF(expr, truepart, falsepart)
expr-- The expression to evaluate.
truepart-- The value to return if the expression is true.
falsepart-- The value to return if the expression is false.
Example: myDataColumn.Expression = "IIF(total>1000, 'expensive', 'dear')
Hope this helps!




Reply With Quote