How Do You Create A Crosstab Query From Scratch In Microsoft Access?
Crosstab queries compress the query results and display them in a spreadsheet-like fashion. These instructions apply to Access 97. From the database window, click on the Query tab. Click on New. A New Query dialog box opens. Click on Design View, then click on OK. The Show Table dialog box appears. Click on the tab that lists the tables or queries that you want to use. Click the name of each object (tables or queries) that you want to add to the query. Click Close. Add fields to the Field row. Specify the query criteria (how you want to separate out information from the selected fields, such as all records with a value greater than 5). Click Query Type on the toolbar. Click on the Crosstab icon. Identify the fields you want to use for the rows. Click the Crosstab row and then click Row Heading. To define the column headings, click the Crosstab column, then click Column Heading. Identify the field values that you want to use in the crosstablulation by clicking on the Crosstab row and th
