Running Totals

F

Frank

I have several fields that I want to sum and display a text box with a
running total. I do not want to store the total I just want to display the
running total.

Thank you for any assistance you can offer.

Frank
 
K

Klatuu

If you mean fields in the form's record source, then create a hidden text box
for each field (if it is not already bound to a control on the form). Then
in the text box where you want to show the sum use the Control Source
property:
=Nz(textbox1,0) + Nz(textbox2,0) + NzUtextbox3,0)
 
J

Jeff Boyce

Frank

"several fields" implies totalling "across".

"running total" implies totalling "down".

Please describe what you are trying to do a bit more...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
F

Frank

Jeff,

I have 10 text boxes in my form that are set by control source to the
database fields. I would like to show a textbox in my form that will show a
total of the 10 text boxes. I do not need to database this text box I just
want to show a total of the other 10 text boxes.

When I say "running" I just mean that when one of the 10 text boxes has a
new entry made that the totaling text box will update.

Thank you
 
F

Frank

Thank you, this works great.

Klatuu said:
If you mean fields in the form's record source, then create a hidden text box
for each field (if it is not already bound to a control on the form). Then
in the text box where you want to show the sum use the Control Source
property:
=Nz(textbox1,0) + Nz(textbox2,0) + NzUtextbox3,0)
Click to expand...
 
J

Jeff Boyce

It sounds like you've already got a workable solution.

By the way, if your underlying table holds multiple fields you are trying to
add (total), you may be dealing with ... a spreadsheet!

If you'll post a description of your underlying table structure, the folks
in the newsgroup may be able to offer alternate approaches that would let
you take advantage of the relationally-oriented features/functions in
Access.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top