View Single Post
  #1  
Old May 17th, 2010, 05:18 PM posted to microsoft.public.access.queries
Cam
external usenet poster
 
Posts: 253
Default Multiple criteria IIF function help

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")