<div>
Edited text of question<br />

</div>


<div>
Sum() is the function you use at the group footer. &nbsp;You could use the Expression Builder to create your Control Source property. &nbsp;You can lookup more about this function by using the help file and search for 'SQL aggregate functions'.<br />
<br />
Good Luck,<br />
Martin<br />
<br />

</div>


Sum() is the function you use at the group footer.  You could use the Expression Builder to create your Control Source property.  You can lookup more about this function by using the help file and search for 'SQL aggregate functions'.

Good Luck,
Martin



<div>
<div class="content wysiwyg-content">
I have a field for name, balance, a payment date and a payment amount. &nbsp;In a report I would like to group by name and at the end of that grouping - get the balance. &nbsp;So if Smith had a balace of 100.00 and made a payment on 10-08-98 for 10.00 and a payment on 10-09-98 for 10.00 then I would a space for it to say current balace of $80.00. &nbsp;Make sense?
</div>
</div>


I have a field for name, balance, a payment date and a payment amount.  In a report I would like to group by name and at the end of that grouping - get the balance.  So if Smith had a balace of 100.00 and made a payment on 10-08-98 for 10.00 and a payment on 10-09-98 for 10.00 then I would a space for it to say current balace of $80.00.  Make sense?

Is RunningSum the function I need?

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.