Running total field in form footer

[cdl1701]

I have a form that I want to display the running total of two seperate fields from my table and have them displayed in the footer. One is Investment field and the other is Worth field.

I created an unbound text box and placed the following code.

=Sum(CollectionTable1!Investment)

but all I am getting is an #error in the field. Everything that I have been looking at says that should work but I must be doing something wrong?

Any Ideas?

 

[fredk]

You say you want to add two seperate fields - use the following in the control source of the field you want the new value:

=([your first field]+[your second field)

Fred

 

[cdl1701]

Actually I want a running total of each field not add the 2 together. Basicly I want a running total of the field for all records together not just the current on that I am looking at.

If this was my table showing the records:
Person Investment Worth
-----------------------------------------------
John $20.00 $80.00
Mary $20.00 $80.00
Bob $20.00 $80.00
==============================================
Totals $60.00 $240.00

I would want a running total for each of these at the footer of my form.

 

[Remou]

Have you tried:
=Sum([Investment])

As the control source for your textbox, where Investment is the name of the field, rather than the control, that you wish to sum?

 

[cdl1701]

yep still give me an #error. I have also checked to make sure that I have everything spelled correctly also.

 

[Remou]

An off the edge suggestion:
=DSum("Investment","tblTable")