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
Solved

Calculating A Total From A Form or Table

Posted on 2004-09-02
2
297 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 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 20 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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

828 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