8
860sharp
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
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