In Access, the function is =IIF. Look here for syntax

http://www.techonthenet.com/access/f...vanced/iif.php