• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

Sub totals in access tables 2007

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
mishlce
Asked:
mishlce
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
...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
 
Rey Obrero (Capricorn1)Commented:
0
 
Jeffrey CoachmanMIS LiasonCommented:
^
Yes, nice big screenshots in that one...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now