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?
 
You must log in or register to reply here.

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

Access Daily Entry with multiple entries per field 0
Subform Calculations 7
Delay in getting subform total to calculate 2
Unremovable horizontal scroll bar on subform 1
How to make a sum of a sub-form on the main form 2
Total Detail on Continuous Form 2
Sum 2
Retrieve a value from an unbound control on a subform 4

Back
Top