Wizard to create a crosstab query
With a crosstab query you calculate in Access to a sum, average or similar values. In addition, the results can be clearly grouped.
- The easiest way to create a crosstab query with the wizard.
- Launch the wizard from Access 2010 by clicking on the tab "Create" select "query wizard" to select.
- Now select "crosstab query wizard" and confirm with "OK."
- In the next step, select the data source. This can be either a table or a query.
- Click "Next" and select the desired row headers. Either select this and click on the button with the Symbol ">" or use a double-click.
- You can select a maximum of three fields for the row headings.
- After you have re-clicked on "Next", select the desired column headings.
- Select on the next page, a field and a function to calculate the summary values of the columns.
- Here are various possibilities, such as sum, average, Max or Min, depending on the type of data available.
- Enable or disable on the same page, the check box "a total calculate for each row", the row totals to include or exclude.
- The last step is to give your crosstab query a meaningful name and then display the results.
Crosstab query creating
In the next article you can read how to create a Access form to update.
