Sum

[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

 

[sweet_dreams]

Hi,

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

Hope this helps,
Sebastian

 

[John]

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