The answer is a Crosstab Query
The answer is a Crosstab Query
In Microsoft Access, the crosstab query presents summary information in a compact format similar to a spreadsheet. It makes this summary information easier to read and understand. This query is able to calculate an average, sum, or other aggregate functions like count, and then group the results by two sets of values.