Summing each subform line

N

natalie

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?
 
K

Klatuu

See the Orders form and subform in the Northwind database. It has an
excellent example there.
 
N

natalie

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?
 
Top