Calculating A Total From A Form or Table

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
LVL 4
GarrettyAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
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
 
GarrettyAuthor Commented:
WORKS PERFECT!!

thanks LSMConsulting
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.

All Courses

From novice to tech pro — start learning today.