Multiple criteria IIF function help

C

Cam

Hello,

I am trying to create an IIF query field where if RtgGrp not equal NA or
Non, the return Yes, otherwise return No. But it is not working. What is
wrong with the formula? Thanks

NoNONV?: IIf([RtgGrp]<>"NA" or "Non","Yes","No")
 
F

fredg

Hello,

I am trying to create an IIF query field where if RtgGrp not equal NA or
Non, the return Yes, otherwise return No. But it is not working. What is
wrong with the formula? Thanks

NoNONV?: IIf([RtgGrp]<>"NA" or "Non","Yes","No")
Click to expand...

You have to repeat the Criteria Field name fo each criteria:

NoNONV?: IIf([RtgGrp]<>"NA" or [RtgGrp]<>"Non","Yes","No")

Perhaps an easier expression to use would be:

NoNONV?:IIf([RtgGrp] In("NA","Non"), "No","Yes")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF function help in query 3
IIF statement in query calculated field 5
IIF function, multiple IIF 0
iif in the criteria 3
iif and between 3
Busted IIf function 3
iif, or, else? 3
How to display multiple IIf results in one column 1

Top