Access IIf Query with multiple OR conditions

0
votes

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:

Action: IIf([NewComments]="A" Or "E" Or "F" Or "D","CANCEL","SUSPEND")

When I run that it generates CANCEL for every cell, even though that's not correct.

Can you help?

1
sqlms-accessiif

1 Answers

1
votes

Use IN:

IIf([NewComments] IN ("A", "E", "F", "D"), "CANCEL", "SUSPEND")