Microsoft® Office Access 2003 Inside Out

Summarizing Information with Totals Queries

Sometimes you aren’t interested in each and every row in your table—you’d rather see calculations across groups of data. For example, you might want the total product purchase amount for all companies in a particular state. Or you might want to know the average of all sales for each month in the last year. To get these answers, you need a totals query.

Totals Within Groups

If you’re the housing facilities manager, you might be interested in producing sales and usage numbers by facility or by date range. For this series of exercises, open HousingDataCopy.mdb and start a new query on tblFacilities and add tblReservations to the query design. Include in the field grid the FacilityName field from tblFacilities ...