Microsoft Access Database: Using the IIF Function In An Access Query

Microsoft Access has a rich set of functions when calculating values including the very popular IIF function. If you have used the IF function in an Excel spreadsheet, then you’ll feel at home here as it’s the same!

Take a quick look at the video below to know the basics

Microsoft Access IIF Function (IF/Then)

The above video was demonstrated with an earlier version of Microsoft Access and is still in use with the latest version  (2010).

You can nest the IIF function (one function inside another) or any other function to really open up the flexibility of how users calculate with Microsoft Access queries, forms, reports and macros.

About Ben

Ben Beitler is a highly proficient software developer & consultant with over 20 years experience of database design and implementation of CRM management systems, bespoke applications using VBA (mainly Excel spreadsheets & Access databases). Currently he is also working as coach for individuals and small businesses who are looking to use the Internet to market their businesses focusing on SEO and traffic building to websites. He is a fellow member of the The Institute of IT Training which is the world's first professional body for IT training professionals which sets standards and code practices within the industry. Having successfully run several businesses, Ben currently provides training, consultancy and development in Access and Excel ranging from small to large companies including Ford, Toyota, HSBC, Barclays, PWC, Deloitte, Sage and many others. Even though he is based in the UK (in and around the London area), his services have been used as far as Australia consulting and developing systems with software specialists. Ben has created website resources for Microsoft Access database and Microsoft Excel spreadsheet which are free to use which collate news articles, tips 'n' tricks, video tutorials and support questions from the more popular websites around including Google, Yahoo and YouTube.
This entry was posted in MS Access, Queries, Utilities and tagged , , , , . Bookmark the permalink.

One Response to Microsoft Access Database: Using the IIF Function In An Access Query

  1. Ben Beitler says:

    When using the IIF function in your query, form or report, do not nest too many IIF’s. It will only confuse you (or others) when trying to understand and maintain the logic. There are other techniques and functions available as a better work-around including building you own VBA functions.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>