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

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.