O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

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

Creating a Summary Report

Although both database object types let you display your table and query records, one thing you can do in a report that you can’t with a form is to summarize your data within a report. For example, if you created a summary report of all orders and grouped the report’s contents by product, you could add a summary function to find the total sales for each product. You could also find the minimum, maximum, or average value of orders for each listed product.

Build a Summary Report

  1. Click the Create tab.

  2. Click Report Wizard.

  3. Click ...

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