access query to show top 10 customers by sales rep.

[Colleen2]

I have the query built for each rep & customer by sorted by highest to lowest and now I just want to filter just the top 10 advertisers by sales person

[June7]

Review http://allenbrowne.com/subquery-01.html#TopN

[Colleen2]

That didn't help. I need to pull just the top customer sales by rep. I have the data totaled by sales id, customer and amount. Now I just want to see the top 10 clients for each sales id including the customer. Below is sample of the data

[Gicu]

no data included...

[Colleen2]

Sales Assignment Code	Sales Assignment Employee Name	Customer Name	Sum of Grand Total
SA0001	Sales Rep1	1	60,000.00
SA0001	Sales Rep1	2	42,383.49
SA0001	Sales Rep1	3	39,514.98
SA0001	Sales Rep1	4	39,500.00
SA0001	Sales Rep1	5	31,799.00
SA0001	Sales Rep1	6	27,450.00
SA0001	Sales Rep1	7	20,000.00
SA0001	Sales Rep1	8	15,949.58
SA0001	Sales Rep1	9	15,800.00
SA0001	Sales Rep1	10	13,200.00
SA0002	Sales Rep2	11	65,032.00
SA0002	Sales Rep2	12	64,975.00
SA0002	Sales Rep2	13	64,800.00
SA0002	Sales Rep2	14	56,600.00
SA0002	Sales Rep2	15	55,064.37
SA0002	Sales Rep2	16	48,750.00
SA0002	Sales Rep2	17	41,300.00
SA0002	Sales Rep2	18	39,790.00
SA0002	Sales Rep2	19	30,900.00
SA0002	Sales Rep2	20	27,300.00

[Colleen2]

here is the data

Sales Assignment Code	Sales Assignment Employee Name	Customer Name	Sum of Grand Total
SA0001	Sales Rep1	1	60,000.00
SA0001	Sales Rep1	2	42,383.49
SA0001	Sales Rep1	3	39,514.98
SA0001	Sales Rep1	4	39,500.00
SA0001	Sales Rep1	5	31,799.00
SA0001	Sales Rep1	6	27,450.00
SA0001	Sales Rep1	7	20,000.00
SA0001	Sales Rep1	8	15,949.58
SA0001	Sales Rep1	9	15,800.00
SA0001	Sales Rep1	10	13,200.00
SA0002	Sales Rep2	11	65,032.00
SA0002	Sales Rep2	12	64,975.00
SA0002	Sales Rep2	13	64,800.00
SA0002	Sales Rep2	14	56,600.00
SA0002	Sales Rep2	15	55,064.37
SA0002	Sales Rep2	16	48,750.00
SA0002	Sales Rep2	17	41,300.00
SA0002	Sales Rep2	18	39,790.00
SA0002	Sales Rep2	19	30,900.00
SA0002	Sales Rep2	20	27,300.00

[Gicu]

Can you show us what you tried following June's suggestion? You need to group by SalesId and get to top 10 customer ids ordering by grand total descending.

[Colleen2]

Thank you - was able to get it to work with a select query on the customer