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