Improve company productivity with a Business Account.Sign Up

x
?
Solved

Sub totals in access tables 2007

Posted on 2012-03-28
3
Medium Priority
?
276 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

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

606 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