IIF function question

[Guest]

I have this function in my query: URG_IN:
IIf([MCAUTH_URG_IN]"",N,[MCAUTH_URG_IN]). The MCAUTH_URG_IN field can be
many letters of the alphabet, but if it is blank I want it to be an "N". Can
someone tell me what is wrong with this query?

Thanks.

 

[Guest]

You omitted the equal sign and quotes around the 'N'.
URG_IN: IIf([MCAUTH_URG_IN]="","N",[MCAUTH_URG_IN]).

 

[Guest]

Thanks. It worked.

You omitted the equal sign and quotes around the 'N'.
URG_IN: IIf([MCAUTH_URG_IN]="","N",[MCAUTH_URG_IN]).
--
KARL DEWEY
Build a little - Test a little

I have this function in my query: URG_IN:
IIf([MCAUTH_URG_IN]"",N,[MCAUTH_URG_IN]). The MCAUTH_URG_IN field can be
many letters of the alphabet, but if it is blank I want it to be an "N". Can
someone tell me what is wrong with this query?

Thanks.

 

[John W. Vinson]

I have this function in my query: URG_IN:
IIf([MCAUTH_URG_IN]"",N,[MCAUTH_URG_IN]). The MCAUTH_URG_IN field can be
many letters of the alphabet, but if it is blank I want it to be an "N". Can
someone tell me what is wrong with this query?

Thanks.

The syntax [MCAUTH_URG_IN]"" is meaningless - there is no operator between the
fieldname and the empty string, and an empty string is not the same as NULL in
any case.

Try not using IIF at all - instead try

NZ([MCAUTH_URG_IN], "N")

The NullToZero function NZ will return a letter N if the value in the field is
NULL.

John W. Vinson [MVP]