I have used a SELECT UNION in order to get round the fact that Access truncates Memo fields.
My query reads:
SELECT DISTINCT [surname] & " " & [forenames] AS fullname, Answer.grade, Answer.[grade mark], Answer.[actual mark], Answer.[penalty type], Answer.[penalty percentage], [Project...