I have a query to count the number of records each employee (with certain criteria) has.
4 fields: EmplNumber,DateWorked,Code,Count
The count field I added and just put a one in each record. So that in my report I am grouping by Employee Number, and just showing the summary info, after summing the count for each employee. Is there a way for the report to show the employee with the highest count? I can't get it to sort by that sum count.(or I don't really know how).
Do I need to change my query?
4 fields: EmplNumber,DateWorked,Code,Count
The count field I added and just put a one in each record. So that in my report I am grouping by Employee Number, and just showing the summary info, after summing the count for each employee. Is there a way for the report to show the employee with the highest count? I can't get it to sort by that sum count.(or I don't really know how).
Do I need to change my query?
