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


puppydogbuddy
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

=IIf([PayOff]=True,0,[Text34])

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

nico5038
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.

Nic;o)
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

nico5038
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....

Nic;o)
Oct 31 '08 #6

Post your reply

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