How to select an average of the lowest 10 record values

  • Thread starter Thread starter jgeniti
  • Start date Start date
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
 
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?
 

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

Complex problem - taking a weighted average of 8 of a series of 10 values 2
Loop through a record set to change a currency field based on average difference of two fields 0
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
How to find the difference between values of multiple records 12
How to find the Average of cells containing a value 1
How to copy a selected database record into a set of string variables 11
How to find the largest product of an array of values? 3
How to get values from selected item in a gridview 1

Back
Top