<div>
Assuming that your single quotes are there for emphasis, and are not actually part of the control source property, the entry of:<br><pre><code class="code-1 nolinks" id="code-20-43284036-1"><span>Sum([TaxPrinBal])</span>
</code></pre>should work. &nbsp;However, if those fields in your recordset are formatted using the Format( ) function in the query you use for the form, then they have become strings, and you would need to use:<pre><code class="code-1 nolinks" id="code-20-43284036-2"><span>SUM(Val([TaxPrinBal])</span>
</code></pre>
</div>


<div>
Thanks Dale. &nbsp;These are not formatted fields and the quotes are not included in the real code.<br><br>I removed the = sign preceding the Sum to arrive at<br><pre><code class="code-1 nolinks" id="code-20-43284087-1"><span>Sum([TaxPrinBal])</span>
</code></pre>That changed my #Error to #Name. &nbsp;Still no total.
</div>


mlcktmguy

<div>
<div class="content wysiwyg-content fr-view">
Access 2013, Continuous form with columns TaxPrinBal, TaxPenaltyBal and TaxInterestBal from Recordsource 'tblBIRTPayment_BuildPayment_Work_Local'. &nbsp;In the table each field is defined as Double, Format Standard, Decimal places 2.<br>In each case the Field Name and Control Source on the forma are exactly the same.<br><br>I want to total each column in the form footer. &nbsp;For the total of column 'TaxPrinBal' I have a field in the footer with this control source '=Sum([TaxPrinBal])'. &nbsp; Instead of getting a total for the column I am seeing #Error.<br><br>I do the same for each of the columns and get #Error in every one.<br><br>Thought this would be pretty simple, I know I've done it dozens of times but not working on this form.<br>Any idea what I'm doing wrong.
</div>
</div>



Access 2013, Continuous form with columns TaxPrinBal, TaxPenaltyBal and TaxInterestBal from Recordsource 'tblBIRTPayment_BuildPayment_Work_Local'.  In the table each field is defined as Double, Format Standard, Decimal places 2.
In each case the Field Name and Control Source on the forma are exactly the same.
I want to total each column in the form footer.  For the total of column 'TaxPrinBal' I have a field in the footer with this control source '=Sum([TaxPrinBal])'.   Instead of getting a total for the column I am seeing #Error.
I do the same for each of the columns and get #Error in every one.
Thought this would be pretty simple, I know I've done it dozens of times but not working on this form.
Any idea what I'm doing wrong.

#Error summarizing a column on a form

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.