CODEWITHSUNDEEP
sqlms-accessiif
Katie
Katie

Reputation: 105

Access IIf Query with multiple OR conditions

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?

Upvotes: 0

Views: 7580

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1271151

Use IN:

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

Upvotes: 1

Related Questions