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 guide: Windows 7 -- Free Quick Reference Card. Ask any pro computer user and they'll tell you: having to constantly reach for the mouse not only causes strain on your neck and back - it also slows you down. Imagine being able to control your computer the way it was meant to be - using your keyboard! With this guide, you'll learn to dramatically increase productivity using the best ways to navigate, organize, and manage your Windows PC and its contents. Most importantly: the majority of these shortcuts, tips, and tricks are valid for any PC, netbook, and laptop running Windows XP, Vista, and 7. Use it to brush up on the basics and to find alternate methods to your favorite commands. This printable quick reference guide is yours to use, distribute, and share! Click here to download this guide now! Note: this guide 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.