<div>
Perfect! Thank you very much.
</div>


<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 0 points for Shooter54's comment <a href="https://www.experts-exchange.com/questions/28616003/How-to-base-the-sum-of-a-control-on-the-state-of-another-control-checkbox.html?anchorAnswerId=40606578#a40606578" rel="ugc">#a40606578</a><br />
<br />
for the following reason:<br />
<br />
Simple and concise solution to what to me was a difficult problem.
</div>


I've requested that this question be closed as follows:

Accepted answer: 0 points for Shooter54's comment #a40606578 [https://www.experts-exchange.com/questions/28616003/How-to-base-the-sum-of-a-control-on-the-state-of-another-control-checkbox.html?anchorAnswerId=40606578#a40606578]

for the following reason:

Simple and concise solution to what to me was a difficult problem.

<div>
Looks like you inadvertently selected your own comment as the answer. &nbsp;I suggest you click on Request Attention at the top (right after your question) to someone fix this.
</div>


Looks like you inadvertently selected your own comment as the answer.  I suggest you click on Request Attention at the top (right after your question) to someone fix this.

<div>
I inadvertently accepted my own response as the solution. (sorry, new user) IrogSinta, ID 40606608 provided me the solution. Please resolve.
</div>


I inadvertently accepted my own response as the solution. (sorry, new user) IrogSinta, ID 40606608 provided me the solution. Please resolve.

<div>
<div class="content wysiwyg-content">
I have a subform for which I am summing one of the controls, using the simple expression =Sum([LineTotal])<br />
<br />
I would like that sum to only include the records for which a checkbox control is &quot;true&quot;, but I'm not certain how to modify my expression to accomplish this. (see attachment)<br />
<br />
Thank you in advance.<a href="https://filedb.experts-exchange.com/incoming/2015/02_w07/898000/clip.jpg" target="_blank" title="clip.jpg (196 KB)"><img alt="clip.jpg" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/02_w07/800_898000/clip.jpg" /></a>
</div>
</div>


clip.jpg

I have a subform for which I am summing one of the controls, using the simple expression =Sum([LineTotal])

I would like that sum to only include the records for which a checkbox control is "true", but I'm not certain how to modify my expression to accomplish this. (see attachment)

Thank you in advance.

How to base the sum of a control on the state of another control (checkbox)

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.