Show All

Create a crosstab report

1. Create a crosstab query.

   How?

   1. In the Database window, click Queries under Objects, and then click New on the Database window toolbar.
   2. In the New Query dialog box, click Crosstab Query Wizard, and then click OK.
   3. Follow the directions in the wizard dialog boxes. In the last dialog box, you can choose to run the query or see the query's structure in Design view.

      Note  If the resulting query isn't exactly what you want, you can rerun the wizard or change the query in Design view.

2. Open the query in Design view.

3. Display the query's property sheet by double-clicking anywhere outside the design grid and outside the field lists.
4. In the ColumnHeadings property box, type the column headings you want to appear in the report, separating each one with a semicolon. If a column heading contains spaces, enclose it in double (") quotation marks.

   For instance, in a query showing sales by quarter, you would type:

   "Qtr 1";"Qtr 2";"Qtr 3";"Qtr 4"

5. Create a blank report that is bound to the crosstab query.

   How?

   1. In the Database window, click Reports under Objects.
   2. Click the New button on the Database window toolbar.
   3. In the New Report dialog box, click Design View.
   4. Select the crosstab query, and then click OK.

6. Add the controls for the fields you want to appear in the report.

7. Place labels for the row headings and column headings in the page header.

8. Place text boxes for the row headings and column values in the detail section.