Access: Crosstalk query - how it works

With a crosstab query in Access, for example, you can clearly display sales by customer and item. You can find out how to carry out such a query in this practical tip.

Assistant to create a crosstab query

With a crosstab query, you calculate a total, an average, or similar values ​​in Access. In addition, results can be clearly grouped.

• The easiest way to create a crosstab query is with the wizard.
• You start the wizard from Access 2010 by selecting the entry "Query wizard" in the "Create" tab.
• Now select "Crosstab Query Assistant" and confirm with "OK."
• In the next step you select the data source. This can be either a table or a query.
• Click on "Next" and select the desired line headings. Either mark it and click the button with the ">" symbol or use a double click.
• You can select a maximum of three fields for the row headings.
• After you click on "Next" again, select the desired column headings.
• On the next page, select a field and a function to calculate the column summary values.
• Depending on the data type, there are various options available here, such as sum, mean, max or min.
• On the same page, check or uncheck the "Calculate total for each row" check box to include or exclude the row totals.
• In the last step, give your crosstab query a meaningful name and then display the results.