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

Totals Queries

Totals queries enable you to find sums of values by using aggregate functions. Their capacities are extremely important and useful. You can count the number of orders in March, find the average freight per order, calculate the total number of units on hand for a product category, and so on.

How is creating a totals query different from creating other queries? In terms of technique alone, the major difference is the addition of the Total row to the design grid. You make selections in the Total drop-down list to designate the aggregate function you want to use, the grouping you want, and which fields are to be used for criteria. Although the utility of each function obviously depends on database and user, I focus on three of the most important aggregates: Sum, Avg, and Count.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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