Jimbo Razza
Board Regular
- Joined
- May 21, 2005
- Messages
- 114
Hi There
Is there some way to create a query that will list the top 5 values of a certain feild and have them grouped by another feild.
For example I have the follow feilds in a table:
Employee Name
Employees Manager
Sales For Month.
I need to see the top 5 sales for the month for each Manager.
Is there some way to create a query that will list the top 5 values of a certain feild and have them grouped by another feild.
For example I have the follow feilds in a table:
Employee Name
Employees Manager
Sales For Month.
I need to see the top 5 sales for the month for each Manager.