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.
  • 1952
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


More Articles

© 2020 DotNetHeaven. All rights reserved.