Top 5 by group



I have a large file of athletic data. I have already made a query called "Rank by Pace by School" That has Sorted the data returning the fastest times per kid (no repeated kids) Per school. Table is called "Main Data"

File looks like (expr1 is the mile pace in secs)
School Name expr1
a Joe 357.7
a Jim 367.7
a John 378.7
a Fred 391.1
a Alan 395.7
a Frank 397.5
a Harry 398.7
a Bob 399.7
a Alan 400.2
b Alex 357.7
b Bill 367.7
I would like a query that takes the query above and only returns the top 5 results per school.
So for school a, it would only return results Joe through Alan. For school b returning only Alex through...whoever.

Can someone help me with this. I am trying to do it through design mode, but that may not be possible without going into SQL


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Top with aggregate function 1
Lookup function 4
Top 5 by a GROUPing? 1
Top N Records minus lower scores 8
TOP values 4
Query to show top x% by group 11
Trouble with Top N by Group query 2
Select Top 5 1