#Error in the report

  • Thread starter Thread starter Public
  • Start date Start date
P

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?
 
You can change your control sources of the totals text boxes from:
=Sum([Your Field])
to
=IIf(HasData,Sum([Your Field]),0)
 
Back
Top