Code:
TRANSFORM Avg(qryEnterResults.TestScore) AS AvgOfTestScore
SELECT qryEnterResults.slotID_FK, qryEnterResults.Firstname, qryEnterResults.surname, qryEnterResults.MathsClass, qryEnterResults.PaperTier, Avg(qryEnterResults.TestScore) AS [Total Of TestScore]
FROM qryEnterResults
WHERE (((qryEnterResults.MathsClass)="10x/mm1") AND ((qryEnterResults.[slotID_FK])=7))
GROUP BY qryEnterResults.slotID_FK, qryEnterResults.Firstname, qryEnterResults.surname, qryEnterResults.MathsClass, qryEnterResults.PaperTier
ORDER BY qryEnterResults.surname
PIVOT qryEnterResults.PaperNumber;