By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 2,091 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,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
Share this Question
Share on Google+
2 Replies


RuralGuy
Expert 100+
P: 375
I would put your txtdeposittotal in a query and do the calc there. Then sum it in the footer of the form.
Dec 25 '10 #2

P: 51
Will give it a try - thanks for the reply
Dec 28 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.