Share this Page URL

Chapter 9. Extending Your Use of Queries > Summarizing Data with a Crosstab Que... - Pg. 306

Extending Your Use of Queries 306 5. On the Query menu, click Crosstab Query. Notice in the query design grid, shown here, that rows labeled Crosstab and Total are added and that the Show row is removed. In the Crosstab row, you select which field to use as the query's column heading, which field or fields to use as row headings, and which field's values will be summarized. The Total row lets you select the fields by which records will be grouped and the summary function you want to use.