A query that can display the record on row, column, heading structure is called crosstab query.
A crosstab query is a type of select query. When users run a crosstab query, the results display in a datasheet that has a different structure from other types of datasheets.
- A crosstab query calculates a statistic for data that is grouped by two different type of information. Crosstab query calculate a sum, average, count, or other type of total for data that is grouped by two types of information one down the left side of the datasheet and another across the top.
- This select query groups summary data vertically by employee and category.
- A crosstab query can display the same data, but groups the data both horizontally and vertically so that the datasheet can be more compact and easier to read.