How did they get the "Total" line for Business Account Ledger?

[Klingrap]

I am working with the Business Account Ledger template (offered on this site)
and noticed a "Total" line on the Account Transaction List form. This form
appears to be a split form, and (I thought) only shows a list of records. On
this form, there is a "total" line after the list of records. (Actually, it
does much more than calculate the total). How was that done?

 

[golfinray]

I usually drag down the form footer and put a textbox in the footer and use
it for total calculations. For example, set the RecordSource of the textbox
=sum([yourfield])

 

[Klingrap]

Yes, thank you for that tip. I will probably use that feature if I can't
solve this riddle. However, I'm curious this particular form because it
appears to be on the "datasheet" itself, not on the footer of the form.
--
Thanks,
Klingrap

I usually drag down the form footer and put a textbox in the footer and use
it for total calculations. For example, set the RecordSource of the textbox
=sum([yourfield])
--
Milton Purdy
ACCESS
State of Arkansas

I am working with the Business Account Ledger template (offered on this site)
and noticed a "Total" line on the Account Transaction List form. This form
appears to be a split form, and (I thought) only shows a list of records. On
this form, there is a "total" line after the list of records. (Actually, it
does much more than calculate the total). How was that done?

 

[golfinray]

Then it is a good possibility that the calculation is done in the query the
form is based on. Milt
--
Milton Purdy
ACCESS
State of Arkansas

Yes, thank you for that tip. I will probably use that feature if I can't
solve this riddle. However, I'm curious this particular form because it
appears to be on the "datasheet" itself, not on the footer of the form.
--
Thanks,
Klingrap

I usually drag down the form footer and put a textbox in the footer and use
it for total calculations. For example, set the RecordSource of the textbox
=sum([yourfield])
--
Milton Purdy
ACCESS
State of Arkansas

I am working with the Business Account Ledger template (offered on this site)
and noticed a "Total" line on the Account Transaction List form. This form
appears to be a split form, and (I thought) only shows a list of records. On
this form, there is a "total" line after the list of records. (Actually, it
does much more than calculate the total). How was that done?