1-866-245-5224 sales@keystonelearning.com

Access 2007: Using the Datasheet Total Row

Access 2007: Using the Datasheet Total Row

The Totals row is a brand-new feature in Access 2007. With the Totals row, the process of counting rows or performing other common totaling functions has just become much easier.

In fact, if you happen to be an Excel user, you’ll notice that the new Totals row closely resembles the Totals row that you find in Excel 2003 Lists or Excel 2007 Tables.

When you show a Totals row, you get to choose the Count, Sum, Average, Min, or Max functions from a drop-down list.

Adding a Totals Row to a Datasheet

     
  1. Open the table in Datasheet view
     
  2.  
  3.  Click the Totals command in the Records group on the Home tab
     

Figure 40. Total Row

    3.       Click inside the cell that displays the “Total” label

Figure 41. Total Row Function Options

    4.       Choose a function

Hiding a Totals Row

You never have to remove a Totals row from a datasheet. Instead, you hide the row. When you display the row again, Access remembers the function that you applied to each column in your datasheet and the row appears in its previous state.

     
  1. Open the table in Datasheet view
     
  2.  
  3.  Click the Totals command in the Records group on the Home tab