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: A Crossroads for Windows XP Users: Windows 7 or Windows 8?. Microsoft's Windows XP has officially been decommissioned as of April 8, 2014, meaning that Microsoft will not longer support the software insofar as security updates are concerned. So, is it really that dangerous to continue using Windows XP? Security experts agree that the answer to that question is a resounding 'Yes!' If you are still using Windows XP, you should upgrade as soon as possible; otherwise, you run a significantly increased risk of being infected by malicious software (malware) - resulting in ID theft, credit card fraud, or worse. This eBook helps users decide which operating system would be the most viable option, depending on your current configuration. 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.