Solved

Sum only positive or negative values on an ACCESS 2003 form

Posted on 2013-05-29
2
1,054 Views
Last Modified: 2013-05-29
I have a form for which I want three values, the sum of all the claim amounts, then the sum of only the positive amounts and a sum of only the negative amounts.  The sum of all claim amounts is easy, but there does not seem to be a SumIf function where I can tell the text control to only sum positive numbers - is this possible?

Sandra
0
Comment
Question by:ssmith94015
2 Comments
 
LVL 33

Accepted Solution

by:
Norie earned 500 total points
ID: 39204895
Sandra

You could use DSum.

Negative:

=DSum("[YourField]", "[TableOrQueryName]", "[YourField]<0")

Positive:

=DSum("[YourField]", "[TableOrQueryName]", "[YourField]>0")
0
 

Author Closing Comment

by:ssmith94015
ID: 39204963
Yes, was missing the idea of the less or greater, thank you.
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

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

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

25 Experts available now in Live!

Get 1:1 Help Now