Query IIF Expression Help

[knowshowrosegrows]

I have a very specific problem. I have a report where the following expression works great:
=IIf([terminated]="-1","No",IIf([graduated?]="-1","No",IIf([dropped]="-1","No","Yes")))

I now want to do this in a query and this expression throws an error:


Active:=IIf([terminated]="-1","No",IIf([graduated?]="-1","No",IIf([dropped]="-1","No","Yes")))

Can someone translate this into an expression that will work in a query?

[pbaldy]

You wouldn't want the = in the query. Also, this may be simpler:

IIf([terminated]="-1" OR [graduated?]="-1" OR [dropped]="-1","No","Yes")

[ssanfu]

If [terminated] OR [graduated?] OR [dropped] are boolean (yes/no) fields, then should use -1 (no quotes) or TRUE (my preference).

"-1" is a text string.

For the query:

Active: IIf([terminated]= -1 OR [graduated?]= -1 OR [dropped]= -1,"No","Yes")

(Yes, I copied Paul's expression )

Also shouldn't use special characters or spaces in field names....>> [graduated?]