#error due to blank report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Nz() will not work if the record doesn't return any records.
You can use an expression like:
=IIf([HasData],[Some Expression],0)
 
Back
Top