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?