Add a total Row to your MS Access 2007 Access Table
Prior to Access version 2007, you could calculate totals of your data in query, report or form view. Now, Access 2007 lets you add a Total row field to your tables which seems to make a lot more sense doesn't it?
Let's suppose you want to find out the average number of hours your employees worked per week in August.
Follow the steps below to add a total row to the hours field column in your Employees database:
- Open your Employees database.
- In the Navigation pane, double-click the tale that records the hours worked for the month of August.
- Click the Hours field name in the open table.
- Click the Home tab.
- Click the Totals button.
- Scroll to the end of the Hours column and click the Total row field's list arrow.
- Select Average.
To find the minimum or maximum hours worked by one employee, select either Maximum or Minimum.
To obtain the total of all hours worked for the month, select Sum in step 7.
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
Free eBook: Refreshing, Resetting, and Restoring: A Guide to Recovery Options in Windows 8. When do you refresh, reset, or restore your Windows 8 PC -- and what's the difference? In a nutshell, resetting reverts a machine back to a base image of the initial installation, while refreshing is much less drastic and keeps applications and user data safe. So, which one should you choose and under what circumstances? With this eBook, you'll learn about the powerful additions to the arsenal of recovery tools found in Windows 8. Click here to download this eBook now! Note: this eBook is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.