Microsoft Access- alternative to the IF function

December 2016





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 :

This document entitled « Microsoft Access- alternative to the IF function » from CCM (ccm.net) 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.