I have 3 fields: Name, Department, Score

Score is split into 1A,1B,2A,2B,3A,3B
Department into Maths, Biology, Physics etc.
How do I create a report which gives me a total of 1A's, 1B's etc in a Department.

i.e

Report

Department Maths
1A = 3
1B = 1
2A = 2

etc etc

In a query:

SELECT TableName.Department, TableName.Score, Count(TableName.Score) AS CountOfScore
FROM TableName
GROUP BY TableName.Department, TableName.Score;