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
Got a programming related question? You
may want to post your question here
Programming Answers here