• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 34. Using Queries > Creating a Crosstab Query

Creating a Crosstab Query

A crosstab query presents the information in spreadsheet-type format; you can select the fields to use for rows and the field to use for the columns.

Starting a crosstab query:

1.
In the Database window, click the Queries tab.

2.
Click the New button on the toolbar.

3.
In the New Query dialog box, select Crosstab Query Wizard (Figure 34.38).

Figure 34.38. Select Crosstab Query Wizard and click OK.


4.
Click OK.

5.
Follow the wizard steps, clicking Next on each page. Select the table or query containing the records, up to three fields for the row headings, a field for the column headings, and a calculation to include.

6.
On the last page, type a name for the query or accept the default name and click Finish.

7.
Run the query.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint