This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

  • Article

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.