R
Rachel F.
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!
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!