Grand Total in a Continous Form

[GLEberts]

I am trying to calculate a Grand Total in a continuous form. This question has probably been beaten to death but I could not find any answers or solutions on how to solve. I am trying to stay away from storing a calculated field in a table.

This is what I have -

Form: fmdepositsbydaterange
Textbox: “txtdeposittotal” with control source =CDbl(nz([txtamt1],0))+CDbl(nz([txtamt2],0))+CDbl(nz([txtamt3],0))+CDbl(nz([txtamt4],0))+CDbl(nz([txtamt5],0))+CDbl(nz([txtamt6],0))+CDbl(nz([txtamt7],0))+CDbl(nz([txtamt8],0))+CDbl(nz([txtamt9],0))+CDbl(nz([txtamt10],0))

The Million Dollar question is - In a continuous form what is the best solution to calculate the
Grand total of all the totals of “txtdeposittotal”?

What I have tried in a text box in the footer of the continuous form is:
(1) =Sum([txtamt1]+[txtamt2]+[txtamt3]+[txtamt4]+[txtamt5]+[txtamt6]+[txtamt7]+[txtamt8]+[txtamt9]+[txtamt10])

(2) =Sum(([txtamt1])+([txtamt2])+([txtamt3])+([txtamt4])+([txtamt5])+([txtamt6])+([txtamt7])+([txtamt8])+([txtamt9])+([txtamt10]))

(3) =Sum(([txtamt1])+Sum([txtamt2])+Sum([txtamt3])+Sum([txtamt4])+Sum([txtamt5])+Sum([txtamt6])+Sum([txtamt7])+Sum([txtamt8])+Sum([txtamt9])+Sum([txtamt10]))

(4) =sum([txtdeosittotal])

(5) =sum[txtdeposittotal]

I have been able to calculate the sum of the lines in a query but not been able to calculate the Grand Total in have it and have the answer show in the text box in the footer of the continuous form.

Can someone push me in the correct direction?

My instincts tell me that I need to calculate from a query.

Thanks
Gary

[RuralGuy]

I would put your txtdeposittotal in a query and do the calc there. Then sum it in the footer of the form.

[GLEberts]

Will give it a try - thanks for the reply