Report grouping totals

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
 
X

Xcelsoft

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
 
E

Ed Robichaud

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