Dolphin.com.bd
Office Suite Tutorial => Microsoft Office Access => Topic started by: bbasujon on August 15, 2012, 05:22:17 PM
-
Function: IIf()
Purpose: The IIf() function allows the conditional return of different values depending upon whether an expression evaluates to true or false.
Usage: IIf(expression, true_value, false_value)
Expression is the expression you wish to evaluate.
True_value is the value that should be returned if expression is true.
False_value is the value that should be returned if expression is false.
Returns: true_value or false_value.
Examples and Special Cases
IIf(Weight > 200, "Overweight", "Normal")
Returns "Overweight" for any weight value greater than 200 pounds and "Normal" otherwise.