Report grouping totals

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


-----Original Message-----
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


.

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

"Xcelsoft" wrote in message
...
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


-----Original Message-----
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


.