<div>
Try this in the control source of a textbox in the foooter of your report:<br />
<br />
= ABS(SUM([Amount] * (Notes&lt;&gt; &quot;Duplicate&quot; AND Notes &lt;&gt;&nbsp;&quot;Revision&quot;))<br />
<br />
Make sure that Amount and Notes are fieldnames, not control names
</div>


Try this in the control source of a textbox in the foooter of your report:

= ABS(SUM([Amount] * (Notes<> "Duplicate" AND Notes <> "Revision"))

Make sure that Amount and Notes are fieldnames, not control names

<div>
Now when I run the report the sum is $2,653.00...no matter what the total should be. &nbsp;I can run it for one week or 10 weeks and the total is $2,653.00. &nbsp;When I entered the syntax as you wrote...it stated I was missing a closing ) which I added. &nbsp;Amount and Notes are field names.
</div>


Now when I run the report the sum is $2,653.00...no matter what the total should be.  I can run it for one week or 10 weeks and the total is $2,653.00.  When I entered the syntax as you wrote...it stated I was missing a closing ) which I added.  Amount and Notes are field names.

<div>
Sorry...<br />
Where did you add the missing paren? That could make a difference. &nbsp;It should go at the end:<br />
<br />
= ABS(SUM([Amount] * (Notes&lt;&gt; &quot;Duplicate&quot; AND Notes &lt;&gt;&nbsp;&quot;Revision&quot;)))<br />
<br />
<br />

</div>


Sorry...
Where did you add the missing paren? That could make a difference.  It should go at the end:

= ABS(SUM([Amount] * (Notes<> "Duplicate" AND Notes <> "Revision")))




ConditionalSum.mdb

<div>
Thank you so much! &nbsp;That worked perfectly.
</div>


Thank you so much!  That worked perfectly.

<div>
<div class="content wysiwyg-content">
I'm trying to put a sum in a report in access which will total dollars in the field AMOUNT where the field NOTES does not equal &quot;Duplicate&quot; or &quot;Revision&quot;<br />
&nbsp;<br />
Not sure how...any help would be appreciated.<br />
<br />
Thanks,
</div>
</div>


I'm trying to put a sum in a report in access which will total dollars in the field AMOUNT where the field NOTES does not equal "Duplicate" or "Revision"
 
Not sure how...any help would be appreciated.

Thanks,

How do I create a conditional Sum in 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.