Top 5 SQL in an Aggregate Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top