Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Top 5 by Group query
Follow up question. Is there a way to make it show only the teams that have 5 runners to show. Eliminating teams with only 1-2 athletes?- 860Sharp
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Top 5 by Group query
Well it seems to be working. Only it is giving me the 5 slowest, not the 5 fastest- 860Sharp
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Top 5 by Group query
It doesn't like A.expr1<=B.expr1- 860Sharp
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Top 5 by Group query
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...- 860Sharp
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
