Create & populate your new table using method 1.
Call it tblCarRace or similar with fields CarNo(PK), RunNo and RaceTime (not Time as its a reserved word)
Create a query qryRaceTime similar to this:
Code:
SELECT tblCarRace.CarNo, Min(tblCarRace.RateTime) AS FastestTimeFROM tblCarRace
GROUP BY tblCarRace.CarNo
ORDER BY Min(tblCarRace.RateTime);
To get the rank order, either use the query in a report or use a ranking query approach,
I use the Serialize function for this: https://www.access-programmers.co.uk...ight=serialize
Alternatively Allen Browne explains how to do this using subqueries here: http://allenbrowne.com/ranking.html
Whichever method you prefer, adapt the above query to include it
HTH