Returning #N/A if null value

  • Thread starter Thread starter Adam
  • Start date Start date
A

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!
 
How do I get my query to return #N/A
when null, but keep my numeric values numeric if not?
Click to expand...

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.
 
Back
Top