- What is the purpose of a row heading in a crosstab query?
- How many column headings can you specify in a crosstab query?
- Can we swap rows and columns in crosstab?
What is the purpose of a row heading in a crosstab query?
Row heading field—identifies another parameter about the data that is to be studied. In the Car Sales database example below, these headings are car make and model. The query datasheet contains one row listing each. Crosstab queries can have a maximum of three row heading fields.
How many column headings can you specify in a crosstab query?
In the Crosstab row, specify whether to use the ranges as row headings or column headings. Remember that you can specify from one to three row headings, and one column heading.
Can we swap rows and columns in crosstab?
You can interchange rows and columns in a crosstab, a chart based on a crosstab, or both. For example, if you have a crosstab report that has few rows and many columns, you can swap the rows and columns to make the report easier to read.