Prev: split address field
Next: Parameter Queries
From: Paul Digby on 8 Aug 2006 08:20
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;

From: Duane Hookom on 8 Aug 2006 09:40
The
"Paul Digby" <PaulDigby(a)discussions.microsoft.com> wrote in message
news:C10EFD7F-3604-495A-8DBD-079FBAAA5952(a)microsoft.com...
> 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;
>


From: Duane Hookom on 8 Aug 2006 09:41
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.

--
Duane Hookom
MS Access MVP

"Paul Digby" <PaulDigby(a)discussions.microsoft.com> wrote in message
news:C10EFD7F-3604-495A-8DBD-079FBAAA5952(a)microsoft.com...
> 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;
>


 | 
Pages: 1
Prev: split address field
Next: Parameter Queries