Need a query to show a label based on a value? IIf takes a condition, a result when it is true, and a result when it is false. In this example, a credit limit of $1000 or more displays High Credit. Anything lower displays Normal. The query calculates that label without storing it in the table. Watch the video for more ways to use IIf in your Access queries and forms.
For a complete step-by-step video tutorial on this topic, including additional examples and explanations, please visit https://599cd.com/IIF.
No comments:
Post a Comment