Solved

How to get the MS access function DSUM to work?

Posted on 2016-11-20
4
45 Views
Last Modified: 2016-11-21
I am trying to sum the total number of “SubmittedGC” in 2016 on report named “rptMonthlyGoodCatchWinners”. I am using the DSum Function and I get nothing but errors.
CustomerContactModernV2.accdb
0
Comment
Question by:cssc1
4 Comments
 
LVL 57
ID: 41895086
<<on report named “rptMonthlyGoodCatchWinners”>>

I haven't looked at your DB, but be aware that built-in for reports is the ability to do a running sum over a group or report.

For the control that has what your trying to sum, look at the "Running Sum" property.

Jim.
0
 
LVL 34

Expert Comment

by:PatHartman
ID: 41895320
How much time are we supposed to invest to determine where the error happens?
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 41895594
Use the report footer - see attached.

/gustav
CustomerContactModernV2.1.accdb
0
 

Author Closing Comment

by:cssc1
ID: 41896013
Works Great, thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

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…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

911 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now