Look At Summarized Or Aggregate Data In Access 2010
In this article I am going to explain Look At Summarized Or Aggregate Data In Access 2010.
Look at summarized or aggregate data
We can add a total row to the product subtotals query that we created in the previous example by using the following procedure
After run the product subtotals query.
First we click the home tab, and then click the totals tab in records group.
A new row add at the end in the datasheet, and click the cell named total.
Click the arrow to view the available aggregate functions.
Then we select the count.
- Then we click the adjoining cell in the datasheet.
- We select the total sub column and click sum, then show the total value.
- At the end we leave the query open in datasheet view.
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here