Calculating negative and positive numbers

R

rugiem

I am trying to do calculations in a field that has both positive and negative
numbers. I need to calculate the positive numbers. Can someone help?
 
D

Duane Hookom

Does this question relate to Access Reports? Could you be a little more
descriptive? How about providing some sample records and how you would
expect them to display?
 
R

rugiem

I am cal calculating doctors charges. Some of the charges are eg. $182.00,
$90.00.($25.00) and $25.00 . I am getting a total of $$272 instead of
$297.00. Can you help? I relates to Access reports. I am looking to get the
right calculations
 
R

Rick B

The result of those three numbers IS $272.

182 + 90 + 25 - 25 = 272

Why would you want to ignore negative numbers? Don't you want to include
corrections, paymnets, and/or credits when you come up with a total?
 
A

Al Camp

There is probably a more sphisticated way to do this, but I would add a
calculated field to my report query such as...
PosCharges : IIF(DoctorChg <= 0, 0, DoctorChg)
Then you can =Sum(PosCharges) in any footer.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
R

rugiem

I want access to ignore the negative number and give me the total of the
positive numbers.
 
D

Duane Hookom

In addition to Al's suggestion, you can add a text box with a control source
like:
=Sum(Abs([Charge]>0) * [Charge])
 
Top