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
Medium Priority
1,309 Views
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
Question by:ssmith94015

LVL 35

Accepted Solution

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

ID: 39204963
Yes, was missing the idea of the less or greater, thank you.
0

## Featured Post

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…
###### Suggested Courses
Course of the Month10 days, 7 hours left to enroll