Distinct Items

[James T]

I have a query that I am trying to create (aren't we all).

Fields in the query are:

Employee
Client
Task
Count of Task.

This information comes from employees entering
Timesheets. However during a period of time i.e. a week,
an employee could record time for the same Task more than
once.

I need to have the Count of Task field only return 1
instance of the task per employee/client.

Is there a way to do this????

Thanks

James

 

[Van T. Dinh]

Post the Table Structure and the SQL of your attempts and
corresponding results.

Van T. Dinh
MVP (Access)

 

[Kelvin Lu]

You just answered you own question with the name of your field. Turn the
Totals options (the summation button in the toolbar) on in the query design
window. Set Employee, Client, and Task to Group By under the total row and
for the count create a field "Count Of Task : Count([Task])" with the total
row set to expression.

Kelvin Lu