Summing first time from each race

carlton123

Registered User.
Local time
Today, 09:16
Joined
Mar 18, 2011
Messages
48
I have a table POSITIONS which has (position,time,club,race_link,name) i have managed to get the fastest time for each club in each race using the Min in a query the problem is i have another query that then adds up the times and works out the fastest club from that query but it includes all the times from every person in that club in every race i just dont get it
 
Nor do I. Post some sample data from the relevant sources and then what the query should return based on that sample data. Include field and table names, use this format for posting data:

Table1NameHere
Field1NameHere, Field2NameHere, Field3NameHere
David, 12, 4/3/2008
Steve, 8, 5/16/2010
Amy, 2, 6/6/2007
 
Positions_Table
Race_Link,Position,Member,Flytime,Ringnumber
64,1,Fred,00:56:53,GB34
64,2,Fred,00:57:34,GB35
64,4,Fred,00:58:53,GB89
64,5,Fred,01:00:23,GB12
64,3,Alf,00:57:50,Gf1234
64,6,Alf,01:57:50,Gf1234
65,1,Fred,00:56:53,GB34
65,2,Fred,00:57:34,GB35
65,4,Fred,00:58:53,GB89
65,5,Fred,01:00:23,GB12
65,3,Alf,00:57:50,Gf1234
65,6,Alf,01:57:50,Gf1234

looking to get a sum of the first time for each name in each race(race_link)
 

Users who are viewing this thread

Back
Top Bottom