<div>
Why not simply<br><br><pre><code class="code-1 nolinks" id="code-20-43091195-1"><span>=[Negative]+[Positive]</span>
</code></pre>
</div>


<div>
The statement should work if the fields are really called 'Negative' and 'Positive', but I would simplify it to:<br><br>=Sum([Positive]+[Negative])<br><br>I'd also check the underlying data. &nbsp; Look at what the reports is based on (table or query) directly and see if the negative numbers are truly negative. &nbsp; They might be displayed as a negative using a format property, but actually be positive.<br><br>Jim.<br><br>
</div>


<div>
I have uploaded the Access database. &nbsp;The Report is called PrintChangeOrderTEST.<br>Fields to sum ------ &nbsp; &nbsp; (-81600 &nbsp;+2417.50 &nbsp;-261.80) &nbsp; &nbsp; I should get $79,444.30 &nbsp; &nbsp;NOT 2417.50.<br><br>I have checked all the tables and queries. &nbsp; Table= ChgOrd-Table &nbsp; &nbsp; &nbsp;Query for Report= Query1<br>I still can't figure out what is wrong. ANy solution to this?<br>Thank you...<br>Rick<br><a href="https://filedb.experts-exchange.com/incoming/2020/05_w21/1459363/BookingsNew2019---Copy.accdb" rel="ugc"></a><br><a href="https://filedb.experts-exchange.com/incoming/2020/05_w21/1459363/BookingsNew2019---Copy.accdb" rel="ugc"></a><br><a href="https://filedb.experts-exchange.com/incoming/2020/05_w21/1459363/BookingsNew2019---Copy.accdb" rel="ugc">BookingsNew2019 - Copy.accdb</a>
</div>


BookingsNew2019---Copy.accdb

ES-Components

<div>
Thank you Jim!!!!! It was a simple solution to something that I just could not see after staring at it foe so long.<br>Yes, the formula worked fine! And yes I will also correct the data.<br>Thanks again for your help!<br><br>Rick
</div>


<div>
<div class="content wysiwyg-content">
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.<br />
Field names: Negative and Positive. &nbsp;Values are -81,861 &nbsp; and &nbsp;2,500.<br />
The formula below gives me a result of 2,500. &nbsp; The correct answer should be -79,361. <br />
<br />
What am I doing wrong?<br />
<br />
=Sum(([Negative])+([Positi<wbr />ve]))
</div>
</div>


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?

=Sum(([Negative])+([Positive]))

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.