How to select an average of the lowest 10 record values

J

jgeniti

Hello,
I have a table with lap times for racers and I would like to get an
average of each racers lowest 10 laps. I know this can be done and it
seemed a lot simplier in concept, but I'm struggling. Any help would
be greatly appreciated.

Thanks in advance,
James

Racer Name,
LapID, LapTime, RacerName, RaceID
658 28.433 Brownie 48
659 27.989 Donnie F 48
 
J

jgeniti

Thanks Steve,
I never knew about Top property. When I use the sort on the grouped
query, it's sorting the average lap times of each racer as apposed to
sorting the lap times prior to the top property being applied.
Basically, I'm still not getting the top 10 fastest laps.
Is there something I can do in SQL view?
 
Top