By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,638 Members | 2,249 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,638 IT Pros & Developers. It's quick & easy.

Sum Of text box in access report(Please it is urgent)

P: 77
Hi all,

I have a report in access. in detail section of the report I have a text box which holds the price for each inventory. There are some calculations in the control source of the text box. I need to have sum of the values that appear in this text box at the end of report. if I add a text box at the report footer and set the control source to sum(text1),each time I run it report will ask for text1!

How should I have the sum for that text box?
Oct 31 '08 #1
Share this Question
Share on Google+
5 Replies

Expert 100+
P: 1,923
if the control source of the field being summed is [Amount], then the textbox with the sum should look like this: =Sum([Amount])
Oct 31 '08 #2

P: 77
Thanks for reply but the control source of that tex box is


and text34 is

=IIf([tbl_Payment subreport2].[Report].[HasData],[TotalAmount]-[tbl_Payment subreport2].[Report]![AccessTotalsPaymentAmount],[TotalAmount])

So teh only chance taht I have is to sum the last text box.
Oct 31 '08 #3

Expert 2.5K+
P: 3,072
The "easy" way out is to add the IIF() in your query and sum this query field in the footer.

Oct 31 '08 #4

P: 77
Thanks But is there any way I can have sum of the text box it is too hard to change that query.
Oct 31 '08 #5

Expert 2.5K+
P: 3,072
Too hard to change the query ?

It's almost the same IIF() you code in your text field, see my sample.

When you need query help, post the SQL text here and I'll show you.

I haven't found a way to sum a calculated text field yet....

Oct 31 '08 #6

Post your reply

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