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

Summing amounts in a text box

P: 76
Hello,

I have a report in which I'm trying to sum the numbers that appear in [Text33]. The control source of [Text33] is:

=IIf([Date] Between [Enter Start Date (MM/DD/YY)] And [Enter End Date (MM/DD/YY)] And [Text34] Like "Overtime - *",[Text24],"0")

and [Text24]'s control source is Hours from a table. In [Text35], the box where I want the sum to appear, I have:

=sum([Text33])

which seems like it should work. Unfortunately, every time I view the report, it first prompts me to enter something in a text box with the title "Text33". What am I doing wrong?

Thanks,

Charlie
Dec 21 '06 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hello,

I have a report in which I'm trying to sum the numbers that appear in [Text33]. The control source of [Text33] is:

=IIf([Date] Between [Enter Start Date (MM/DD/YY)] And [Enter End Date (MM/DD/YY)] And [Text34] Like "Overtime - *",[Text24],"0")

and [Text24]'s control source is Hours from a table. In [Text35], the box where I want the sum to appear, I have:

=sum([Text33])

which seems like it should work. Unfortunately, every time I view the report, it first prompts me to enter something in a text box with the title "Text33". What am I doing wrong?

Thanks,

Charlie

Can you post a reply to this thread on Wednesday/Thursday to bump it up the list. It may not get much attention over Christmas.

Happy Holidays.

Mary
Dec 25 '06 #2

ADezii
Expert 5K+
P: 8,597
Hello,

I have a report in which I'm trying to sum the numbers that appear in [Text33]. The control source of [Text33] is:

=IIf([Date] Between [Enter Start Date (MM/DD/YY)] And [Enter End Date (MM/DD/YY)] And [Text34] Like "Overtime - *",[Text24],"0")

and [Text24]'s control source is Hours from a table. In [Text35], the box where I want the sum to appear, I have:

=sum([Text33])

which seems like it should work. Unfortunately, every time I view the report, it first prompts me to enter something in a text box with the title "Text33". What am I doing wrong?

Thanks,

Charlie
'I am fairly sure that if the Control Source for a Text Box within a Report contains
'an Expresstion such as [Text33] does, you cannot summmarize on the Text
'Box itself, but namely, you must summarize on the entire expression:

For the Control Source of [Text35], =sum([Text33]) will not work but something like the following should.
Expand|Select|Wrap|Line Numbers
  1. =Sum(IIf([Date] Between [Enter Start Date (MM/DD/YY)] And [Enter End Date (MM/DD/YY)] And [Text34] Like "Overtime - *",[Text24],"0"))
Dec 26 '06 #3

Post your reply

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