Results By Marque



Displays all the driver with more than 5 meeting in that marque

Click to see Race and Speed History by Marque


My SQl query

Finder Query for one marque

SELECT Names.Membno, Names.FullName, ResultsUnion.NameId, Sum(ResultsUnion.ResultsCount) AS SumOfResultsCount, " " & Names.FullName & "
" AS link
FROM (SELECT EventDutyForNames.NameId, Count(1) AS ResultsCount, Cars.CarMake
FROM EventDutyForNames INNER JOIN ((Cars INNER JOIN EventEntryForNames ON Cars.CarId = EventEntryForNames.CarId) INNER JOIN EventResults_speed ON EventEntryForNames.EventEntryId = EventResults_speed.EventEntryId) ON EventDutyForNames.DutyAtEventId = EventEntryForNames.DutyAtEventId
GROUP BY EventDutyForNames.NameId, Cars.CarMake
union
SELECT Names.NameId, Count(1) AS ResultsCount, Cars.CarMake
FROM [Names] INNER JOIN (Cars INNER JOIN RaceHistory ON Cars.CarId = RaceHistory.CarId) ON Names.NameId = RaceHistory.DriverNameId
GROUP BY Names.NameId, Cars.CarMake
)  AS ResultsUnion INNER JOIN [Names] ON ResultsUnion.NameId = Names.NameId
WHERE (((ResultsUnion.CarMake) Like "*Alvis*"))
GROUP BY Names.Membno, Names.FullName, ResultsUnion.NameId
HAVING (((Sum(ResultsUnion.ResultsCount))>5))
ORDER BY Names.FullName;

Finder Query for all marque

SELECT Names.Membno, Names.FullName, ResultsUnion.NameId,
Sum(ResultsUnion.ResultsCount) AS Results,
ResultsUnion.CarMake,
"
& "" target="_blank">"  &  Names.FullName  & ""  as link
FROM  (
SELECT EventDutyForNames.NameId, Count(1) AS ResultsCount, Cars.CarMakeFROM EventDutyForNames INNER JOIN ((Cars INNER JOIN EventEntryForNames ON Cars.CarId = EventEntryForNames.CarId) INNER JOIN EventResults_speed ON EventEntryForNames.EventEntryId = EventResults_speed.EventEntryId) ON EventDutyForNames.DutyAtEventId = EventEntryForNames.DutyAtEventId
GROUP BY EventDutyForNames.NameId, Cars.CarMake
union
SELECT Names.NameId, Count(1) AS ResultsCount, Cars.CarMake
FROM [Names] INNER JOIN (Cars INNER JOIN RaceHistory ON Cars.CarId = RaceHistory.CarId) ON Names.NameId = RaceHistory.DriverNameId
GROUP BY Names.NameId, Cars.CarMake
)  AS ResultsUnion

INNER JOIN [Names] ON ResultsUnion.NameId = Names.NameId
WHERE
(((ResultsUnion.[CarMake]) Like "*Riley*" Or (ResultsUnion.[CarMake]) Like "*Nash*" Or (ResultsUnion.[CarMake]) Like "*GN*" Or (ResultsUnion.[CarMake]) Like "*Austin*" Or (ResultsUnion.[CarMake]) Like "*Alvis*"))
GROUP BY Names.Membno, Names.FullName, ResultsUnion.NameId, ResultsUnion.CarMake
HAVING (((Sum(ResultsUnion.ResultsCount))>5));


or   per page

WHERE  for each page

ResultsUnion.[CarMake] Like "*Riley*"
ResultsUnion.[CarMake] Like "*Nash*" or ResultsUnion.[CarMake] Like "*GN*"
ResultsUnion.[CarMake] Like "*Austin*"
ResultsUnion.[CarMake] Like "*Alvis*"
SELECT Names.Membno, Names.FullName, ResultsUnion.NameId,
Sum(ResultsUnion.ResultsCount) AS Results,
ResultsUnion.CarMake,
"
& "" target="_blank">"  &  Names.FullName  & ""  as link
FROM  (
SELECT EventDutyForNames.NameId, Count(1) AS ResultsCount, Cars.CarMakeFROM EventDutyForNames INNER JOIN ((Cars INNER JOIN EventEntryForNames ON Cars.CarId = EventEntryForNames.CarId) INNER JOIN EventResults_speed ON EventEntryForNames.EventEntryId = EventResults_speed.EventEntryId) ON EventDutyForNames.DutyAtEventId = EventEntryForNames.DutyAtEventId
GROUP BY EventDutyForNames.NameId, Cars.CarMake
union
SELECT Names.NameId, Count(1) AS ResultsCount, Cars.CarMake
FROM [Names] INNER JOIN (Cars INNER JOIN RaceHistory ON Cars.CarId = RaceHistory.CarId) ON Names.NameId = RaceHistory.DriverNameId
GROUP BY Names.NameId, Cars.CarMake
)  AS ResultsUnion

INNER JOIN [Names] ON ResultsUnion.NameId = Names.NameId
WHERE
(((ResultsUnion.[CarMake]) Like "*Riley*" Or (ResultsUnion.[CarMake]) Like "*Nash*" Or (ResultsUnion.[CarMake]) Like "*GN*" Or (ResultsUnion.[CarMake]) Like "*Austin*" Or (ResultsUnion.[CarMake]) Like "*Alvis*"))
GROUP BY Names.Membno, Names.FullName, ResultsUnion.NameId, ResultsUnion.CarMake
HAVING (((Sum(ResultsUnion.ResultsCount))>5));


or   per page

WHERE  for each page

ResultsUnion.[CarMake] Like "*Riley*"
ResultsUnion.[CarMake] Like "*Nash*" or ResultsUnion.[CarMake] Like "*GN*"
ResultsUnion.[CarMake] Like "*Austin*"
ResultsUnion.[CarMake] Like "*Alvis*"