Hi Davd.

Any time you have repleating fields like yours, it indicates that you need a
related table where you can enter the values as many records related to the
original one, instead of many fields. You can then solve the problem easily.

You already have a Student table, with fields:
   StudentID    AutoNumber     primary key
   Surname     Text
   Firstname    Text
   BirthDate     Date/Time

Now you need another table to record the race results for the students.
Assuming that "1mile" means a race distance of 1 mile, this RaceResult table
will have fields like this:
   StudentID        relates to Student.StudentID
   RaceDistance  Number    (1 mile, or 2 miles, or ...)
   RaceTime        Number    (number of seconds.)

You can now create a query into both tables, and show the top 10 times for
any one age group and distance:
1. In query design, drag the RaceTime field into the grid.
In the Sorting row under this field, choose Ascending.

2. Open the Properties box (View menu.)
In the query properties, set the Top Value to 10.

3. Add the criteria to limit the age group. For example, under the BirthDate
field, you might enter:
   Between DateAdd("yyyy", -16, Date()) And (DateAdd("yyyy", -15,
Date() -1)

4. Add the criteria to limit the distance.