Display only best laptimes in query

[RocketMan]

I have a database with a table of individual laptimes for different cars and different circuits with different weather conditions.
I have created a query that lists the fastest times for a car on a certain circuit, and a query for the fastest times on a circuit by different cars.
When I run these queries they list all the times for the specific car on the circuit, while I just wish for it to list the quickest time for the car in the different weather conditions. Also, I want to create a query that enables me to list the quickest times for each individual car on a certain circuit.
My table/queries have the fields - Date, Circuit, Make, Model, Weather, Time (minutes), Time (seconds).


I hope this isn't a stupid question. I'm pretty new to Access (but keen to learn more), so any help is much appreciated.
Thanks.

[pbaldy]

See if this gets you started:

http://allenbrowne.com/subquery-01.html#TopN

[NoellaG]

Hi,
first make sure that minutes and seconds are both together in 1 date/time field, then use a groups query:

select Date, Circuit, Make, Model, min(TimeField)
from [YourTableField]
group by Date, Circuit, Make, Model;

[orange]

Date is a reserved word in Access. You might want to review this by Allen Browne.