IIF Function – Immediate IF in Microsoft Access – If/Then in a Single Function – Conditional




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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads