#Error in the report

[Public]

Hi,
I have developed a report where I have some aggregation functions at the
footer of each group. Evereything works OK when there is data (in the
report). However, when there is no data, #Error appears in the same place.
(It should show 0 since there is no data)

Any ideas?

 

[Duane Hookom]

You can change your control sources of the totals text boxes from:
=Sum([Your Field])
to
=IIf(HasData,Sum([Your Field]),0)

 

[Allen Browne]

Test the HasData property of the report, using IIf()

Details in:
Avoid #Error in form/report with no records
at:
http://allenbrowne.com/RecordCountError.html