Microsoft Access- alternative to the IF function

December 2016


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


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 :

This document entitled « Microsoft Access- alternative to the IF function » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.