count values not including duplicates

[poohtender]

I have a database that lists activities by employees throughouth the day. I
then have reports based on daily, weekly, monthly, quarterly and yearly
activites and the totals of all activities for each period of time. I need to
count the number of employees by the area they worked in to complete these
tasks. When I do this I et a total count of employees names. I need to set
this so the count does not include duplicate names but only counts each
employees name once for the given time period. How would I go about this?

 

[tina]

you can use a Totals query, grouping by area, then the primary key of the
employees' table, then the employee name.

base your report on the Totals query, set a group on the area field, and use
the Count() function in the group footer section.

hth