G
Gina K
I have a query that assigns a rank to competitors in an athletic event.
SELECT tblEventResults.fkAthlete, tblEventResults.fkMeetEventID,
tblEventResults.STimeResult, (SELECT Count(*) FROM tblEventResults AS T
WHERE T.STimeResult < tblEventResults.STimeResult AND T.fkMeetEventID =
tblEventResults.fkMeetEventID)+1 AS SeedPlace, tblMeetEvents.Event,
tblMeet.MeetDate
FROM tblMeet INNER JOIN (tblMeetEvents INNER JOIN tblEventResults ON
tblMeetEvents.MeetEventID = tblEventResults.fkMeetEventID) ON tblMeet.MeetID
= tblMeetEvents.fkMeetID
ORDER BY tblEventResults.STimeResult, tblEventResults.fkAthlete;
Maybe I’m making this harder than it is, but how can I store the field
“SeedPlace†to my “EventResults†table? I’ve searched the discussion groups
but I’m too dumb to find what I’m looking for.
Thanks.
SELECT tblEventResults.fkAthlete, tblEventResults.fkMeetEventID,
tblEventResults.STimeResult, (SELECT Count(*) FROM tblEventResults AS T
WHERE T.STimeResult < tblEventResults.STimeResult AND T.fkMeetEventID =
tblEventResults.fkMeetEventID)+1 AS SeedPlace, tblMeetEvents.Event,
tblMeet.MeetDate
FROM tblMeet INNER JOIN (tblMeetEvents INNER JOIN tblEventResults ON
tblMeetEvents.MeetEventID = tblEventResults.fkMeetEventID) ON tblMeet.MeetID
= tblMeetEvents.fkMeetID
ORDER BY tblEventResults.STimeResult, tblEventResults.fkAthlete;
Maybe I’m making this harder than it is, but how can I store the field
“SeedPlace†to my “EventResults†table? I’ve searched the discussion groups
but I’m too dumb to find what I’m looking for.
Thanks.