problem with dsum

LHEMA · Nov 22, 2005

I need help...in my report I am trying to get the total of accidents that
happen in a department. For example I have 43 department in my report I need
to show that the Road Department has 3 accidents....how can this be done.
Thanks

Duane Hookom · Nov 22, 2005

Group by Department and add a text box in the group footer (or header):
=Count(*)

LHEMA · Nov 22, 2005

It works, thank you

LHEMA

Duane Hookom said:
Group by Department and add a text box in the group footer (or header):
=Count(*)