Hellow everyone,
I have the following query:
SELECT Year, School, Number
FROM tblStudentNumber
GROUP BY Year, Number, School
ORDER BY School, Year
(quite simple :)
I want divide the field [number] with a sum over the numbers, within a school group...
Something like...