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!
How to Fix: Windows 10 Upgrade Failed Error 80240020
Can I Cancel my Windows 10 Reservation and Reserve Later?
- How to Clean Install Windows 10 using Windows 7, 8 License
- No Service Packs For Windows 10; Support ends 2025
- Will Windows 10 Install Automatically?
- Windows 10 Upgrade: Do I have to Reinstall Programs?
- Windows 10 Upgrade: Can I choose 32-bit or 64-bit?
- Which Version of Windows 10 Will I Get (Home or Pro)?
- How to Reserve Windows 10 Upgrade (Free)
- How to Fix: CPU Not Compatible with Windows 10 Error
- Windows 10 Upgrade: Can I keep my Old Windows Install?
- How to Cancel Windows 10 Reservation (Properly)
- Download Windows 10 .ISO (DVD) for Clean Install?
- Microsoft: Windows 10 Will Be The Last Version
- Windows 10 to Natively Support iOS, Android Apps
- Does Windows 10 require the CPU to support PAE?
- Windows 10: Can I Upgrade or do I need a Clean Install?