How do I calculate a total from a continuous form?

[Guest]

I have a continuous form with credits and debits entered (2 columns). I have
a subform, in which I have a text box where I would like it to show the sum
of all of the credits and debits showing in the form. The Record Source is
the table from which the debits and credits come from. My Control Source, so
far, is: =[Credit Amount]-[Debit Amount]. This, however, only gives me the
calculation of the first row of credits and debits. It is not taking into
consideration additional rows. What do I need to do? Thanks, in advance!

 

[John W. Vinson]

I have a continuous form with credits and debits entered (2 columns). I have
a subform, in which I have a text box where I would like it to show the sum
of all of the credits and debits showing in the form. The Record Source is
the table from which the debits and credits come from. My Control Source, so
far, is: =[Credit Amount]-[Debit Amount]. This, however, only gives me the
calculation of the first row of credits and debits. It is not taking into
consideration additional rows. What do I need to do? Thanks, in advance!

That's not how subforms work!

Instead, be sure the Footer (or header, you can use either) of the continuous
Form is visible. Put a textbox in it with a control source

=Sum([Credit Amount]) - Sum([Debit Amount])


John W. Vinson [MVP]