Access 2003

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

Guest

I have a report which has subgroups of departments in the firm. I need to
have a total for the number of people within each department.

I can get the individual groups to add up using:
a control source of =1
a running sum of Over Group
Note: I named this text box "GroupCount"
It adds up like:
Department A
Person A 1
Person B 2
Person C 3
Department B
Person A 1
Person B 2

Name and Job Title are listed under Page Header
Company each person is employed by is listed under Company Header
Departments are listed under Group Header
Individual names are listed under the Detail area

I need to have a final total for each department (with the total number of
people in each department to the right of the Department heading under the
Group Header area)

I tried to add another text box under Group Header, to the right of the
Department with the final total of people, however, I can't seem to get it to
add properly.
Group A has 5 people (which it has).
Group B has 2 people (but the total is now 7).
Group C has 48 people (but the total is now 55)
Group D has 3 people (but the total is now 58) … and so on.

I tried:
=[GroupCount] but this seems to do a running total of the groups, and not
the total of people within the group.
=count(*) but this seems to add the group, then add that group to the next
group
I've tried a few other expressions, but I keep getting Syntax Errors.

Any assistance in totally this report properly would be greatly appreciated.

Thank you.
 
To get the number of records contained in a report group section, you can
add a text box to either the Group Header or Footer section with a control
source of:
=Count(*)
You confused me by mentioning "firms", "Departments", "Company Header", and
your display has only departments and persons.
 
Back
Top