Is Null Problem (very frustrating, need real help)

[sdimaggio]

On a report I have a field called [jumbo rate/hr]. If the data is Empty, ie. null, I want a zero to be placed in the cell. I have tried the following:

=IIf(IsNull([jumbo Rate/hr]),0,[jumbo Rate/hr])

=NZ([jumbo Rate/hr],0)

When I run the report I get an error in the cell for both formulas. Where am I going wrong?

thanks,

Steve.

 

[sdimaggio]

I solved the problem, but thanks for looking.

steve