Solved

Sub totals in access tables 2007

Posted on 2012-03-28
3
259 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

739 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