No records found for SELECT
Participants.LastName,
Participants.FirstName,
Participants.MiddleName,
Participants.Gender,
(YEAR(RaceTypes.RaceDate)-YEAR(Participants.BirthDate)
- (RIGHT(RaceTypes.RaceDate,5) < RIGHT(Participants.BirthDate,5)))
as AGE,
Participants.BirthDateConfidence,
Results.FinishTime,
Results.Status,
Participants.ParticipantID,
(YEAR(RaceTypes.RaceDate)) AS RaceYear
FROM
Results, RaceTypes, Participants
WHERE Results.ParticipantID = Participants.ParticipantID
AND Results.RaceTypeID = RaceTypes.RaceTypeID
AND RaceTypes.RaceName = '1000 Yard '
AND RaceTypes.RaceDate = ''
ORDER BY Results.FinishTime