Datasheet Total

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

Guest

In Access 2000, I have a main form that has a subform containing a datasheet
with an amount column. In a field on the main form, I want to have a running
total of the amounts in the datasheet records. Any ideas on how to do this?
 
On my website (www.rogersaccesslibrary.com), there is a small sample
database called "SubformReference.mdb" which shows this and a number of
other referencing issues with subforms.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Mary Fetsch said:
In Access 2000, I have a main form that has a subform containing a datasheet
with an amount column. In a field on the main form, I want to have a running
total of the amounts in the datasheet records. Any ideas on how to do
Click to expand...
this?
 
Thanks for that information, Roger. I was quite impressed with your website.
Unfortunately, I can't use the total in the footer because my subform is in
datasheet view.
 
Oddly enough, it will still work. You can see this on my sample. Change
the default view of Subsubform1 to Datasheet. The totalling still works.

Create the control with the total in the footer of the form in Continuous
view. Then change the default view of the subform to DataSheet. The total
will still work.
--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Thanks a lot! Since I didn't see the total in my datasheet subform, I didn't
add the textbox to reference it in my main form. Even though the total
doesn't display in datasheet view, it still exists and can be referenced.
That will be a big help. Thanks again!
 
Back
Top