#error

[ielmrani via AccessMonster.com]

Hi,
I can't understand why I am getting the following error: #error
in a report, I am trying to show null if column = zero. Like this:

=IIf([Rev H&W]="0",Null,[Rev H&W])
thanks in advance
Ismail

 

[Pendragon]

Remove the quotes around your zero. The quotes means that you are testing
for the character zero, rather than the number zero.

 

[ielmrani via AccessMonster.com]

thanks for your quick reply. I also solved it by putting the code in the
query instead of the report.

Remove the quotes around your zero. The quotes means that you are testing
for the character zero, rather than the number zero.

Hi,
I can't understand why I am getting the following error: #error

[quoted text clipped - 3 lines]

thanks in advance
Ismail