IIf and IIF Or... Ms Access Statement

Hey,This code works:  IIF ([Contact]=”Owner” OR [City]=”Madrid”,”Yes”,”No”)

This means, if contact is owner or city is Madrid, display Yes.  Otherwise, display No

 

http://www.techonthenet.com/access/functions/advanced/iif.php