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

 Totaltabinaccess2010.jpg

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

 selectcountinaccess2010.jpg

  • Then we click the adjoining cell in the datasheet.

 adjoiningcellinaccess2010.jpg

  • We select the total sub column and click sum, then show the total value.

 selectsuminaccess2010.jpg

  • 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

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.