Summing each subform line

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

Guest

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

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Calculations 7
Access Daily Entry with multiple entries per field 0
Delay in getting subform total to calculate 2
Unremovable horizontal scroll bar on subform 1
Total Detail on Continuous Form 2
Subform (Datasheet) Error 2
How to make a sum of a sub-form on the main form 2
Access Main form/Subform Navigation 0

Top