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

Chapter 8. Building Complex Queries > Summarizing Information with Totals Queri...

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 and the CheckInDate and TotalCharge fields from tblReservations.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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