?
Solved

Sub totals in access tables 2007

Posted on 2012-03-28
3
Medium Priority
?
275 Views
Last Modified: 2012-04-02
How do you use subtotals at the end of a table to see amts of a coulumn without having to pull the table into a qry to get the amt?
0
Comment
Question by:mishlce
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 37778348
...If this is for the entire table, then you want a total (not really a sub total...)

In Access 2007 and newer, In datasheet view, on the ribbon navigate to: Home-->Records-->Totals

Then you will get a dropdown box at the bottom of the table (you may have to scroll down to see it)
In the field you want click in the dropdown box and select "Sum"
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37778358
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37778713
^
Yes, nice big screenshots in that one...
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

598 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question