Solved

Sum only positive or negative values on an ACCESS 2003 form

Posted on 2013-05-29
2
1,026 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

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 …
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

743 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

14 Experts available now in Live!

Get 1:1 Help Now