Dolphin.com.bd

Office Suite Tutorial => Microsoft Office Access => Topic started by: bbasujon on August 15, 2012, 05:22:17 PM

Title: Microsoft Access Function Library: IIf()
Post 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.