?
Solved

How to get the MS access function DSUM to work?

Posted on 2016-11-20
4
Medium Priority
?
72 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
[X]
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
4 Comments
 
LVL 58
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 38

Expert Comment

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

Accepted Solution

by:
Gustav Brock earned 2000 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

777 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