Microsoft Access- alternative to the IF function

May 2017





Issue


Is there a function in Access that allows me to set conditions as in Excel? I have not found the function IF ...

Solution


The equivalent of the Excel IF function is called iif function under Access. Its use and syntax are identical.

iif ( condition, value_true, value_false )
  • value_true:value returned when condition is met
  • value_false: value returned when condition isn't met.

Related


Published by aakai1056. Latest update on November 15, 2011 at 03:57 PM by aakai1056.
This document, titled "Microsoft Access- alternative to the IF function," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).