Microsoft Access 2013 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 wages for all employees for a specific week, or you might want to know the average of all purchases for each month in the last year. To get these answers, you need a totals query.

Totals within groups

If you’re the restaurant manager, you might be interested in producing a weekly wage report, including any overtime wages, based on the total hours worked by employees so that you can prepare payroll paychecks. For this series of exercises, start a new query in the Back Office Software System backup copy web app (BOSSDataCopy.app) with tblEmployees ...