Multiple criteria IIF function help

  • Thread starter Thread starter Cam
  • Start date Start date
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")
 
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")
 
Back
Top