Microsoft Office® Access 2007 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.accdb and start a new query with tblFacilities and tblReservations in the query design grid. Include in the Field row the FacilityName field from tblFacilities ...