Count number of employes by departement

[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

 

[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é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

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

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