459,680 Members | 1,578 Online Need help? Post your question and get tips & solutions from a community of 459,680 IT Pros & Developers. It's quick & easy.

# Grand Total in a Continous Form

 P: 51 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 Dec 25 '10 #1 