Counting occurrences using a query

[RickK]

I need to collect data from a table using a query. The table contains a field for the employee's name (EmployeeID) and each time they enter a call they enter their name in this field. I need to find out who enters the most calls within a given date range. All I want returned in the query is the top ten names and how many total records with their name. So Fred would have 16 records or calls, then John had 12 records........Again only need to the the top ten most calls. Below is my query so far and I am able to pull the entire list by date. I just don't know how to show only top ten and the total amount per person.





Thanks
Rick

[ranman256]

Uncheck date range,
click count button on menu,
change 1 of the EMP IDs to COUNT,
sort this count descending,
set the query property TOP =10

[RickK]

I understand some of this but not all.

Uncheck date range : I removed the check box to show that field
click count button on menu: I assume you are referring to the Totals button which added the total row in the query.
change 1 of the EMP IDs to COUNT: I assume you are saying select COUNT in the Total row for the EmployeeID field
sort this count descending, : I selected descending in the sort row for the EmployeeID field.
set the query property TOP =10: I did nothing here because I am not sure how or where to do this.

If I did everything correct, this does not get me the results that I am after. It return all records during the date range and each record had a 1 for the count. I need it to return the persons name (employeeID) once and the amount of records during that date range for that person, then I need only the top ten.

I am sure I am misunderstanding your instructions.

Thanks
Rick

[aytee111]

Once you have clicked on the Totals icon at the top a new row "Totals" will appear - this is where it all happens.

WorkOrderID - this can be the Count (Count is number of records, it doesn't matter which field is used)
EmployeeID - Group By
Date Started - Where

Sort Descending on the Count field
Top 10 is set in the query's properties

[RickK]

Ok that looks like it worked. The only problem is I am not allowed to enter 10 as the Top values. There is a drop down list and it only allows you to pick one of the following 5,25, 100, 5%, 25%, and ALL.

Thanks
Rick