Returning #N/A if null value

[Adam]

Hello!

How do I create a query that returns #N/A when the value
is null? I am currently using this in line if statement:

PSI: IIf(IsNull([tblPSI.Pressure]),"#N/A",
[tblPSI.Pressure])

However, by using this iif statement, my numeric values
are changed to text. How do I get my query to return #N/A
when null, but keep my numeric values numeric if not?

Thanks for the help!

 

[John Vinson]

How do I get my query to return #N/A
when null, but keep my numeric values numeric if not?

Set a Format property on the field of

#;-#;"0";"#N/A"

The four portions of the format control the display of positive,
negative, zero and NULL values respectively.