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.
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.
Although they have similar names, the Totals row in the design grid and the Total row in a datasheet are not the same.
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here