Count number of employes by departement

C

Céline Brien

Hi everbody,
In my report employes are group by departement.
In the footer of the departement I count the number of employes by
departement.
=Count([NoEmploye]
The problem is coming from the fact that the same employe can work in two or
more classification in the same departement.
How can I count the number of employe without counting those twice or more
????
Thank you for your help,
Céline
 
D

Duane Hookom

Create a totals query that groups by department and employee. Then create
another totals query based on the new query that groups by department and
counts employees. Add this last query to your report's record source so you
can display the count of unique employees per department.
 
C

Céline Brien

Hi Duane,
Hi everybody,
Thank you so much Duane for your answer.
It worked perfectly !
Many thanks again and have a good day.
Céline

Duane Hookom said:
Create a totals query that groups by department and employee. Then create
another totals query based on the new query that groups by department and
counts employees. Add this last query to your report's record source so
you can display the count of unique employees per department.

--
Duane Hookom
MS Access MVP

Céline Brien said:
Hi everbody,
In my report employes are group by departement.
In the footer of the departement I count the number of employes by
departement.
=Count([NoEmploye]
The problem is coming from the fact that the same employe can work in two
or more classification in the same departement.
How can I count the number of employe without counting those twice or
more ????
Thank you for your help,
Céline
Click to expand...
Click to expand...
 
Top