Grand Total on Form from Subform

[Sherry]

Whew, I'm accomplishing my task one step at a time, but I
need more help. I have a form with one record, of course,
but a subform with multiple records. I want to get a grand
total of all the records on the subform and post on the
form. I've tried using SUM to do this, but either that is
not the solution, or my syntax is incorrect. I tried using
SUM on the subform, then linking a field on the form to
that, but that didn't work either. I've been stuck with
this project with absolutely no training in Access
whatsoever, so I'm just winging my way through. Can anyone
help me?

It's greatly appreciated!

 

[JulieD]

Hi Sherry

To show a calculation on the main form you need to include a calculated
field in the sub form's form FOOTER, e.g. control source of text box
=sum([Amount]) (and Name this field something like TotalAmount)
then on the main form you have another text box with the control source of
=[subform's name].[Form]![TotalAmount]
where the "subform's name" is retrieved by right mouse clicking on the
subform when viewed from the main form and looking at the name under
Properties.

Hope this makes sense and helps you.

Cheers
JulieD