Counting Records

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.
 
D

Duane Hookom

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.
 
Top