How do I get a count of records in a group?

[Guest]

I'm trying to get a distinct count of employees per School, per position.
These employees have more than one record but I only want to just count them
once per group. They have an unique number that identifies each employee.

 

[Duane Hookom]

Without further information on your sorting and grouping, I can only suggest
you use text boxes with running sums in group headers with control sources
of =1. You can then reference these values in other "outer" group or report
sections with control sources like:
=txtMyRunningSumTextBoxName

 

[Guest]

I'm not quiet following you. I'm very new at using access Let me give you a
little bit more information.I have my data grouped by Site Name then the job
position. I am needing a count of employees for each job position per site.
As the query is now, it list out the employees for each position, but I just
want a count of the employee, not who they are.

 

[Duane Hookom]

Can you show this as sample records displayed in a report like:

- Site 1
- Job Position A
-John Smith
-Aaron Anderson
- Job Position B
-Mary Johnson
- Site 2
- Job Position B
-
-
-
- Job Position C

etc.

 

[Guest]

Yes that is what my report looks like as of now.

Can you show this as sample records displayed in a report like:

- Site 1
- Job Position A
-John Smith
-Aaron Anderson
- Job Position B
-Mary Johnson
- Site 2
- Job Position B
-
-
-
- Job Position C

etc.

 

[Duane Hookom]

If you want "count of employees for each job position per site" add a text
box to the Job Position header with a control source of:
=Count(*)
This will count the number of records in each Site/Job Position.