O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Crosstab Queries

Crosstab queries are summary queries that enable you to determine exactly how the summary data appears on-screen. Crosstab queries display summarized data in the traditional row-column form of spreadsheets. Crosstab queries use the Access SQL TRANSFORM keyword to indicate that the statements following the keyword are for a crosstab query. (TRANSFORM is not an ANSI SQL keyword.) With crosstab queries, you can perform the following processes:

  • Specify the field that creates labels (headings) for rows by using the Group By instruction.

  • Determine the field(s) that create(s) column headers and the criteria that determine the values appearing under the headers.

  • Assign calculated data values to the cells of the resulting row-column ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required