How Do You Use The Wizard To Create A Crosstab Query In Microsoft Access?
Crosstab queries make it easier to view records by displaying the information in a compact view similar to a spreadsheet. With the wizard, you just need to answer some questions to create the query. These instructions apply to Access 97. Open the Database window. Click on the Queries tab. A query window opens. Click New. A New Query dialog box appears. Click Crosstab Query Wizard. Follow the instructions that the Wizard offers. First, select the table or query that contains the fields you want to use. Click Next. Select up to three fields to be used as row headings. For example, you could sort addresses by Country and then by Region. Click Next. Select the fields you want as column headings. Click Next. Enter any calculations you want performed. Click Next. Name your Query. Click Finish. Your query appears.
