Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: How to Use the IIf() (Immediate If) Function
Article ID: 209192 - View products that this article applies to.
This article was previously published under Q209192
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
You may receive unexpected results when you use the IIf() (Immediate If) function to evaluate an expression. Your results depend on the use of double quotation marks in the function's arguments.
To illustrate how the use of double quotation marks in the IIf() function's arguments can affect the results, follow these steps:
For more information about the IIf function, click Microsoft Access Help on the Help menu, type iif function example in the Office Assistant or the Answer Wizard, and then click Search to view the topic.