I have a report that counts a number of records and displays (or is supposed to) the total.

The report prints a number unless there is no data to report. In that case, it will print #error. Is there a way that I can get it to print a zero?...or have a pop up window to let the user know that there are no records.

TIA
Deb