How to Create a Crosstab Report in MS Access
Access crosstab reports display information that has been summarized and compiled in your database. A quick way to create a crosstab report is to create an auto-report from a crosstab query. The crosstab query will contain all of the fields you need in your report, and the auto-report places the details in a concise format. The crosstab report can be previewed prior to printing.
Other People Are Reading
Instructions
-
-
1
Open Access 2010 and click the "File" tab. Select "Recent." Review the recently used databases and click one to use. The database opens.
-
2
Click the "Create" tab and select "Query Wizard." Select "Crosstab Query Wizard" and click "Ok." Select a table from the provided list. Click "Next." Add fields from the table that will appear as row headings by clicking the field name and the right arrow. Click "Next."
-
-
3
Select the fields that will appear as column heading by clicking the field name and the right arrow. Click "Next." Select the field that will be calculated and the function to use for the calculation. For example, if you are viewing invoices, you can choose to select the "Amount Due" column and the "Max" function to see invoices with the highest amount. Click "Next."
-
4
Type a name for the crosstab query and click "Finish." Review the crosstab query results. Transform this query into a report by clicking the "Report" button on the ribbon. The crosstab report appears in the report print preview window.
-
1
