Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sum only positive or negative values on an ACCESS 2003 form

Posted on 2013-05-29
2
Medium Priority
?
1,309 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 35

Accepted Solution

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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

885 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