IIF function = Jet equivalent to Oracle DECODE function ?

[dmh47]

I'm tying to output a field in a query based on another field, but need to "DECODE" the value:

Census: iff(FLAG="Y","N","Y&quot

The new field is named Census.
I want to display a Y if the FLAG is N, and vice versa.
FLAG is a field in the table on which the query is based.

But I keep getting syntax errors.

Anyone with a solution?

thanks.

 

[r937]

try single quotes instead of double quotes

IIF(FLAG='Y','N','Y')

rudy

http://rudy.ca/