The query runs; however, it’s a big database and tends to hang:
Design
Code
TRANSFORM Count(Numeracy_UAC.UAC_QUAL_SUBJECTS) AS CountOfUAC_QUAL_SUBJECTS
SELECT Numeracy_Enrolled.ACADEMIC_YEAR, Numeracy_Enrolled.ENROLLED_TERM
FROM (((((((Numeracy_Student
INNER JOIN Numeracy_Enrolled ON...