Top 5 SQL in an Aggregate Query

[Guest]

I'm counting occurrences for Questions Grouped by Market Mgr and 3 different
Area Mgrs.

Taking "Top 5" in the SQL statement brings in the overall Top 5 records,
which it should.

I could run code to examine each Area Mgr (w/ the Market Mgr), build a Top 5
and add to a Table after deleting all those Table's records prior to
examining each Area Mgr. Or..is there another way??

Any possibiliity the "Grouping" in an Access Report would display only the
Top 5 for each Area Mgr grouping?

TIA - Bob

 

[Allen Browne]

See:
Subquery Basics: TOP n records per group
at:
http://allenbrowne.com/subquery-01.html#TopN

 

[Guest]

Thank you Allen.

Bob

See:
Subquery Basics: TOP n records per group
at:
http://allenbrowne.com/subquery-01.html#TopN