Simple Count of Records in Report Groups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report including a large number of staff who will be attending training sessions on one of four different dates. I have set up a report whereby the staff are grouped by these dates. I want the report to count the number of staff and show it at the bottom of each group per date

I think this is probably quite a simple query, but I'm only a beginner, so any help would be much appreciated (answers in idiot-proof terms please!

Many thank

Jen
 
The easiest way I have found to do this is in the Record
Source of the Report Add a field and set the value to 1.

The column should look like this:
CountField:1

Then on the report include this field in the detail and
change the visible property to NO.

In the Group Footer sum this field:
the field should have the control source look like this:
=SUM(FieldName)
-----Original Message-----
I have a report including a large number of staff who
Click to expand...
will be attending training sessions on one of four
different dates. I have set up a report whereby the staff
are grouped by these dates. I want the report to count
the number of staff and show it at the bottom of each
group per date.
I think this is probably quite a simple query, but I'm
Click to expand...
only a beginner, so any help would be much appreciated
(answers in idiot-proof terms please!)
 
Add a text box in the group footer with a control source of:
=Count([AnyNonNullFieldName])

--
Duane Hookom
MS Access MVP
--

Jen said:
I have a report including a large number of staff who will be attending
Click to expand...
training sessions on one of four different dates. I have set up a report
whereby the staff are grouped by these dates. I want the report to count
the number of staff and show it at the bottom of each group per date.
I think this is probably quite a simple query, but I'm only a beginner, so
Click to expand...
any help would be much appreciated (answers in idiot-proof terms please!)
 
Jen said:
I have a report including a large number of staff who will be attending training sessions on one of four different dates. I have set up a report whereby the staff are grouped by these dates. I want the report to count the number of staff and show it at the bottom of each group per date.

I think this is probably quite a simple query, but I'm only a beginner, so any help would be much appreciated (answers in idiot-proof terms please!)
Click to expand...


Just add a text box to the group footer and use the
expression =Count(*)
 
Back
Top