• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 16. Creating Queries from Scratch > Using the Total Row in a Query

Using the Total Row in a Query

You can also do calculations in a query, such as totaling numeric information in a particular field or taking the average of numeric information found in a particular field in the query. To add calculations to a query, you must add the Total row to the Query Design grid.

After the Total row is available in the query grid, different calculations can be chosen from a drop-down list in any of the fields that you have chosen for the query. For example, you can sum (total) the numeric information in a field, calculate the average, and even do more intense statistical analysis with formulas such as minimum, maximum, and standard deviation.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint