Multi level (Subgrouped) TOP query

[Phil]

OK. I can run a query that will give me say, the top three
salespersons, sorted by sales, for the month of March.

I can run another one for April. One for May, one for June.

I want to run a single report, that will list top 3 for each "groupby."

Sort it by month and sales, and get.

January Fred 5000
January Joan 4000
January John 3000
February Joan 6000
February Fred 5000
February John 3500
....


how to do?

Thanx for any assistance.

 

[Allen Browne]

See:
How to Create a Top Values Per Group Report
at:
http://support.microsoft.com/kb/208822/en-us

Or:
How to Create a "Top N Values Per Group" Query
at:
http://support.microsoft.com/kb/210039/en-us

 

[Phil]

See:
How to Create a Top Values Per Group Report
at:
http://support.microsoft.com/kb/208822/en-us

Or:
How to Create a "Top N Values Per Group" Query
at:
http://support.microsoft.com/kb/210039/en-us

Thanks a lot.