Continous Form Running Sum

[George]

I have a subform as a continous form - it gets it's info right from the
table. I would like to add a text box to show the running total for one of
the fields. I created the text box but not having any luck with the formula.

The name of the table is: "T-Hours-Earned"
The name of the form is : "F-Compt-Time-History"
The name of the field on the form I want a running sum is: "Hours-Earned"

Any Ideas - I can only get it to sum for each individual line not a grand
total of all lines.

Thanks - George

 

[Albert D. Kallal]

To total a column, simply place a text box in the sub-forms FOOTER...

call the text box whatever (just make sure it is not named to a existing
control/field).

in the text box "control source", simply place the following expression:

=([Hours-Earned])

That is should do the trick. Ms-access will ONLY total reocrds that you have
in the sub-form when you do this....

 

[George]

Thanks but it doesn't work - It gives me the current value just for the row
that
the cursor is in and then blanks out when the cursor moves to the next row.

Is there anything else I can try ?

Thanks

 

[Albert D. Kallal]

sorry, my mistake for the contorl source try:


=sum([Hours-Earned])

 

[George]

Thanks - That works .....