O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required