IIf Statement with null value

[Guest]

I am trying to take numeric data and recode it in order to be used in a
report. There is a null value and I am trying to recode it. My coding is
below. Everything is appearing in the query output except for the null
value. Any advice?

FRS:
IIf([Framingham_Risk_Strata]=Null,"Pre-existing",IIf([Framingham_Risk_Strata]=0,"Low",IIf([Framingham_Risk_Strata]=1,"Intermediate",IIf([Framingham_Risk_Strata]=2,"High"))))

 

[David Lloyd]

Rosalyn:

You may want to try one of the following:

IIF([Framingham_Risk_Strata] Is Null,...
IIF(IsNull([Framingham_Risk_Strata]),...

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am trying to take numeric data and recode it in order to be used in a
report. There is a null value and I am trying to recode it. My coding is
below. Everything is appearing in the query output except for the null
value. Any advice?

FRS:
IIf([Framingham_Risk_Strata]=Null,"Pre-existing",IIf([Framingham_Risk_Strata
]=0,"Low",IIf([Framingham_Risk_Strata]=1,"Intermediate",IIf([Framingham_Risk
_Strata]=2,"High"))))

 

[Guest]

FRS: IIf(IsNull([Framingham_Risk_Strata]),"Pre-existing"......

 

[Guest]

David,

Thanks! This worked perfectly.

Rosalyn