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 the datasheet and the other across the top. For example, the Quarterly Orders by Product query in the Northwind sample database is a crosstab query. You can also display data in a crosstab format by using a PivotTable list or PivotTable form.