Avatar of ES-Components
Flag for United States of America

asked on 

In Access how do I sum Positive and Negative numbers on an Access Report?

I have two Fields from a query that appear on my Access report. I would like to sum these two fields in the footer section of the report. The two fields are Positive and Negative numbers. I have tried the formula below, but the result is incorrect. It seems the formula is only adding positive numbers.
Field names: Negative and Positive.  Values are -81,861   and  2,500.
The formula below gives me a result of 2,500.   The correct answer should be -79,361.

What am I doing wrong?

Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon