Report grouping totals

  • Thread starter Thread starter Ed Robichaud
  • Start date Start date
E

Ed Robichaud

How would I derive totals within a report group that is really a count of
group headers and not the number of records in the detail section?

An example: a report that show employee records, grouped by location,
then by supervisor. I ant the # of employees by location and supervisor,
BUT also want the # of supervisors AND # of locations.

This should be easy, but am stumped for an easier way than using some
complex DCount().

thanks -Ed
 
ED,

You could set a TextBox (MyTextBox) in your group header,
make it invisible, set the Control Source to =1 and set
the Running Sum property to OverGroup.

In the report footer set another TextBox (MyTextBox2)
that references the running sum for the group header.
Set the Control Source of MyTextBox2 to =MyTextBox.

Regards,

Xcelsoft
 
Thanks; I found just that tip after I posted. Don't know why I haven't used
something that useful before!
-Ed
 
Back
Top