Sum

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi
I am viewing my records in a subform in datasheet view.
How do I put a text box in the footer of the subform to sum the record
totals?

TextBox name of each record where the data is to be summed from is QTotal

Regards

John
 
Hi,

Use SUM function. Write below code in your ControlSource property of
your textbox:
=Sum([QTotal])

Hope this helps,
Sebastian
 
Sebastian,
I cannot use the normal Sum() function as the Qtotal TextBox is a calculated
control.
Sorry I forgot to mention that bit.

Regards

John
 

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

Sum Calculated control 2
Datasheet subform total 13
Best way to calc total on a form from a bunch of subforms 3
Retrieve a value from an unbound control on a subform 4
Subform Subtotal 1
Unremovable horizontal scroll bar on subform 1
Conditional Summing 3
Sum Calculated Field Question 1

Back
Top