[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Calculating A Total From A Form or Table

Posted on 2004-09-02
2
Medium Priority
?
316 Views
Last Modified: 2012-06-27
hi

i have a database to keep record of invoices, and on one of my forms, their is the control [Invoice Total]. in my form i have hundereds of records (invoices). is there a way i can create something in my database that will show me the total of all the invoice totals?

help would be appreciated.

thanks
0
Comment
Question by:Garretty
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 80 total points
ID: 11963387
You can set the .ControlSource of a control to something like this:

=DSum("[Invoice Total]", "YourINvoiceTable")

DSum also accepts criteria; see online help for more info
0
 
LVL 4

Author Comment

by:Garretty
ID: 11963430
WORKS PERFECT!!

thanks LSMConsulting
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
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 …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

591 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