Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / August 2006

Tip: Looking for answers? Try searching our database.

DISTINCT records

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul Digby - 08 Aug 2006 13:20 GMT
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 - 08 Aug 2006 14:40 GMT
The
> 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
[quoted text clipped - 18 lines]
> FROM Query7
> GROUP BY Query7.Country, Query7.Circuit, Query7.Driver;
Duane Hookom - 08 Aug 2006 14:41 GMT
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.

Signature

Duane Hookom
MS Access MVP

> 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
[quoted text clipped - 18 lines]
> FROM Query7
> GROUP BY Query7.Country, Query7.Circuit, Query7.Driver;
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.