Create a crosstab query In Access 2010

In this article I am going to explain Create a crosstab query In Access 2010.
  • 3982
Create a crosstab query to add another level of grouping
  • A Crosstab is show query for each month product and show subtotals in access 2010.

Note   A crosstab query cannot be displayed in a web browser.

If we can modify the product subtotals query again so that the query returns rows of product subtotals and columns of monthly subtotals.

We can add a total row to the product subtotals query that we created in the previous example by using the following procedure.

  • First we open home tab and then click view button and select design view.

  • After this process we click show table in query setup group.

  • In show table double click order table and then close the show table.

ordertableinaccess2010.jpg 

  • On the design tab, we click crosstab in a query type group.

  • In the design grid, the Show row is hidden, and the Crosstab row is displayed.

 crosstabinaccess2010.jpg

  • Then we select third column of the design grid, and right click the field row and select the zoom in drop-down list.

 selectzoomtabinaccess2010.jpg

  • When we open the Zoom box, then we type the following code.  

  • Month: "Month " & DatePart("m", [Order Date]), and then click ok.

 typezoomboxcodeinaccess2010.jpg

  • In the Crosstab row, select the following values from the drop-down list.

  • Row Heading for the first column, Value for the second column, and Column Heading for the third column.

 crosstabrowvalueinaccess2010.jpg

  • After this process we click the run in design tab.

  • Displays product subtotals, aggregated by month, and save the query.

 outputinaccess2010.jpg

Ask Your Question

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.