crosstab query
A query that calculates a sum, average, count, or other type of total on records, and then groups the result by two types of information ? one down the left side of a grid (row headings) and the other across the top (column headings). For example, the Quarterly Orders by Product query in the Northwind sample database is a crosstab query.