O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required