#error due to blank report

[Guest]

I have a billing report that uses totals for the month. If there is no
billing the report is blank. If I add old billing to the blank billing I get
#error. How do I get it to add up.

Thanks

 

[Guest]

Hi Mark,

You need to replace NULL values with 0. Try using nz(FIELDNAME, 0)

Damian.

 

[Guest]

Nz() will not work if the record doesn't return any records.
You can use an expression like:
=IIf([HasData],[Some Expression],0)