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

  • Thread starter Thread starter Klingrap
  • Start date Start date
K

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?
 
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])
 
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


golfinray said:
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


Klingrap said:
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?
Click to expand...
Click to expand...
 
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


Klingrap said:
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


golfinray said:
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


Klingrap said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top