See it this works. You may need to add more fields for the mail merge.
Code:
SELECT Athletes.Surname, Athletes.[First Name], Gender.Gender, Athletes.[Event 1], Athletes.[Event 2], Athletes.[Event 3], Athletes.[Event 4], Athletes.[Event 5], Athletes.[Event 6], Athletes.[Event 7], Athletes.[Event 8], Athletes.[Event 9], Athletes.[Event 10]
FROM Gender INNER JOIN (Events RIGHT JOIN Athletes ON (Events.ID = Athletes.[Event 10]) AND (Events.ID = Athletes.[Event 9]) AND (Events.ID = Athletes.[Event 8]) AND (Events.ID = Athletes.[Event 7]) AND (Events.ID = Athletes.[Event 6]) AND (Events.ID = Athletes.[Event 5]) AND (Events.ID = Athletes.[Event 4]) AND (Events.ID = Athletes.[Event 3]) AND (Events.ID = Athletes.[Event 2]) AND (Events.ID = Athletes.[Event 1])) ON Gender.ID = Athletes.Gender;
Edit: Here's same code run thru a formatter:
Code:
SELECT athletes.surname,
athletes.[first name],
gender.gender,
athletes.[event 1],
athletes.[event 2],
athletes.[event 3],
athletes.[event 4],
athletes.[event 5],
athletes.[event 6],
athletes.[event 7],
athletes.[event 8],
athletes.[event 9],
athletes.[event 10]
FROM gender
INNER JOIN (events
RIGHT JOIN athletes
ON ( events.id = athletes.[event 10] )
AND ( events.id = athletes.[event 9] )
AND ( events.id = athletes.[event 8] )
AND ( events.id = athletes.[event 7] )
AND ( events.id = athletes.[event 6] )
AND ( events.id = athletes.[event 5] )
AND ( events.id = athletes.[event 4] )
AND ( events.id = athletes.[event 3] )
AND ( events.id = athletes.[event 2] )
AND ( events.id = athletes.[event 1] ))
ON gender.id = athletes.gender;