About this tutorial:
Video duration: 00:13:16
In this video, I’m going to show you how to use the IIF function, which stands for Immediate IF, to display one value if a condition evaluates to TRUE and a different value if it evaluates to FALSE. This is like having an If/Then statement in your queries and forms. I’ll show you how to display “Past Due” if an order is overdue. We’ll display “High Credit” on credit limits over $1000. We’ll make a query showing the country each customer is in, substituting “United States” for NULL values.
Jayvon from Oakland, California (a Gold Member) asks: I have a form that I would like to display…