[cpollis]

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

 

[OBP]

Charlie, the iif part of your calculation should really be done in the Query that provides the report with data, unless you are trying to control individual Fields.
Having the Criteria in the Query means that only records that meet the if statment will be shown in the report.
The other place for it is in the VB code like the code that I used for your other little problem.