<div>
One way:<br />
Have a text box control with data property set to running sum set to Over All.<br />
Control source set to = IIF(StoreNumber=30, 0, &nbsp;DSales)
</div>


One way:
Have a text box control with data property set to running sum set to Over All.
Control source set to = IIF(StoreNumber=30, 0,  DSales)

<div>
I ended up using DLOOKUP but you gave me the idea with your DSUM solution. Thanks for the help.
</div>


I ended up using DLOOKUP but you gave me the idea with your DSUM solution. Thanks for the help.

<div>
<div class="content wysiwyg-content">
I need to sum the numbers in the DSales field but exclude from the total sum if the StoreNumber equals 30. This is easy in SQL but with Access it's a little trickier. The expressions will be in the report Group Footer. In a perfect world my expression result would = 600 (summing DSales but excluding StoreNumber 30). I don't see a Where clause in access. <br />
<br />
Here is a sample of the data-<br />
<br />
StoreNumber &nbsp; &nbsp; &nbsp; DSales<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500<br />
30 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200
</div>
</div>


I need to sum the numbers in the DSales field but exclude from the total sum if the StoreNumber equals 30. This is easy in SQL but with Access it's a little trickier. The expressions will be in the report Group Footer. In a perfect world my expression result would = 600 (summing DSales but excluding StoreNumber 30). I don't see a Where clause in access. 

Here is a sample of the data-

StoreNumber       DSales
1                             100
2                             500
30                           200

Access Report Expression

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.