title: Access IIf Query with multiple OR conditions
body: <p>This may be a silly question, but I'm trying to fill a column in an Access query using an Iif statement and it's not working as I'd like.  This is what I have:</p>
  
  <pre><code>Action: IIf([NewComments]="A" Or "E" Or "F" Or "D","CANCEL","SUSPEND")
  </code></pre>
  
  <p>When I run that it generates CANCEL for every cell, even though that's not correct.  </p>
  
  <p>Can you help?</p>