I need help calculating a sum in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to access. I need help calculating a running sum. I am setting up a
student database and it has individual financial information such as amounts
paid. I want it to calculate the amount due. Help.

-Brian
 
Hi, Brian.

Assuming that you have a continuous subform of "Transactions" embedded on a
main form displaying details of the account holder, place a summay field in
the subform footer:

= Sum([AmountBilled]) - Sum([AmountPaid]

If you wish to display this result in the main form rather than the subform
footer, set the subform control's Visible property to No, and reference the
control in the Control Source of a main form textbox:

=Me!MySubform.Form![MySummaryControl]

Hope that helps.
Sprinks
 
I am new to access. I need help calculating a running sum. I am setting up a
student database and it has individual financial information such as amounts
paid. I want it to calculate the amount due. Help.

-Brian
Click to expand...

You can calculate a running sum on a Report by putting the field in a
textbox with its Running Sum property set to True.

If you want to see sums onscreen, you can use a Form; it's not clear
just what you want to see - you say a running sum but you also say you
want the amount due (which would presumably be a grand total of costs
minus payments). This could be put onto the Footer of a form or of a
subform.

You should NOT attempt to store a running sum in any Table - calculate
it on the fly instead.

John W. Vinson[MVP]
 
Back
Top