Counting Records

  • Thread starter Thread starter Eric C
  • Start date Start date
E

Eric C

Hello,

I have a report that lists staff members by position.
Some members have more than one position. I would like
to count the total number of staff members in the report
(possibly using a counter), but when a staff member has
more than one position, the counter counts the second
record as well, even though it's the same person.

Any suggestions?

Thanks,

Eric C.
 
Is the report grouped by Staff or by Position? If by Staff
1) add a text box to the staff group header section
Name: txtCountStaff
Control Source: =1
Running Sum: Over All
2) add a text box to the report footer section
Control Source: =txtCountStaff
If grouped by Position, you will need to create a new query that groups by
Staff. Create a query based on this query that Counts the number of records
in the query grouped by staff. Add this final query to your report's record
source.
 
Back
Top