Summing amounts in a text box

[ckpoll2]

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

[MMcCarthy]

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

[ADezii]

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.

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