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
