If NULL then N/A 1

[ptrifile]

I have a simple field in a report that I am trying to have show "N/A" if the field is blank. I am currently simply using

=Avg([days])

I have tried a few variations but cannot seem to get it right using the =IIF(IsNull...function.

Any help is appreciated.

Thank you,

Paul

 

[dhookom]

You should be able to simply use the format property without messing around with the control source:

Format: $#,##0.00[Green];($#,##0.00)[Red];"Zero";"N/A"

Duane
Hook'D on Access
MS Access MVP

 

[ptrifile]

Thanks dhookom! I used

0.0;($#,##0.00);;"N/A"

and I got the desired results.

Thank you for the help!