Summing each subform line

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

Guest

I've got a continuous datasheet subform used for data entry. What I want is
to sum EACH LINE individually, and then have a grand total sum somewhere on
the subform or main form (whichever is easiest). Is this possible?
 
See the Orders form and subform in the Northwind database. It has an
excellent example there.
 
Hi,
I reviewed the form/subform in Northwind and a few other samples I
downloaded. The difference is that these subforms already have pre-existing
dollar amounts in them that are already being summed in a query.

My subform is for data entry and they will always be different. There might
be 10 rows or 30 rows, all with different text and dollar amounts. But I
still need to be able to sum it by row and then have a grand total. I can't
base a query on that, as far as I can see. Any ideas?
 
Back
Top