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

Adding a Totals Row to a Datasheet

Previous versions of Access enabled you to add summary calculations to your reports, but if you viewed your data as a datasheet, the datasheet itself didn’t contain the summary. That meant you either had to create a report that contained a summary calculation at the end, build a query that totaled the values in one or more fields, or do some quick mental arithmetic. In Access 2007, you can add a Totals row to a datasheet, bypassing the need to create a specific report or query to calculate the total.

Add a Totals Row

  1. Display a form in Datasheet view.

  2. Click the Home tab.

  3. In the Records group, click Totals.

    See Also ...

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