DISTINCT records

[Paul Digby]

Ihave a query that has returned the results that I need to narrow down
further. I want to show the fastest time at each circuit, together with the
extra detail (Driver, Team etc). Now I can get the right result, showing 72
rows detailing Country, Circuit and Time, using example 1 below.

However, if I try and add the driver name, it then shows 600+ rows.



Query 7 provides the following colums
Country Circuit Driver Team Car Time Race Pos


Example 1
SELECT Query7.Country, Query7.Circuit, Min(Query7.Time) AS LapRec
FROM Query7
GROUP BY Query7.Country, Query7.Circuit;

Example 2 - Does not work (returns 600+ rows)
SELECT Query7.Country, Query7.Circuit, Min(Query7.Time) AS MinOfTime,
Query7.Driver
FROM Query7
GROUP BY Query7.Country, Query7.Circuit, Query7.Driver;

 

[Duane Hookom]

The

 

[Duane Hookom]

The simplest method might be to save the example 1 query and then create a
new query with example 1 and query 7. Join the Country, Circuit,
LapRe<->[Time] fields.