Multiple criteria IIF function help
On Mon, 17 May 2010 09:18:01 -0700, Cam wrote:
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")
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")
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
|