Microsoft® Office Access™ 2007 Plain & Simple

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