Author Topic: Microsoft Access Function Library: IIf()  (Read 5192 times)

bbasujon

  • Administrator
  • VIP Member
  • *****
  • Posts: 1826
  • I want to show my performance at any where
    • View Profile
    • Higher Education
Microsoft Access Function Library: IIf()
« 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.
Acquire the knowledge and share the knowledge so that knowing,learning then sharing - all are the collection