Have a Access problem. I have 1 master table with records by Sales Rep ID (80001, 80002, and so on). For each of these ID's, i have multiple lines of records that show their sales (Revenue) by customer like follows:
80001 5,000 IBM
80001 7,000 Staples
80005 6,000 Motorola
And so on.
I am trying to get the top 10 deals for each of the Sales Rep ID, In other words
Top 10 for 80001-->Data
Top 10 for 80002-->Data
Can anyoneshed some light on this ?