Create a totals query for summaries In Access 2010

In this article I am going to explain Create a totals query for summaries In Access 2010.
  • 4935
Create a totals query for more complex summaries
  • A totals query is allows to group and summarize data.

  • For Example, If we want to see total sale per product, then we can use sum.

  • Web query does not support aggregate function.

These are the following steps to make summarize product subtotals by product.

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

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

  • The Product Subtotals query opens in Design view.

  • We click design tab and click total tab in the show/hide group.

  • The total row is show query design grid.

 totalrowinaccess2010.jpg

Although they have similar names, the Totals row in the design grid and the Total row in a datasheet are not the same.

  • In the second column of the design grid, in the Total row, select Sum from the drop-down list.

 selectsuminaccess2010.jpg

  • Then we click run in design tab.

 clickruntabinaccess2010.jpg

  • We save our data in 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.