Summing unbound text box in report

[Guest]

I have an unbound text box, called [NoSchools] in the detail section of a
report that gets it's data from Select Case statements in the onprint event .
I want to be able to find the sum of the numbers in this text box, but can't
because it is an unbound text box in a report. The report is based upon a
query.

Any help will be appreciated.

- Steve

 

[Guest]

What do you want to do with the sum? is it something in a report or group or
page footer?
You can sum an unbound text box. Just make the control source
= sum([NoSchools])

 

[Duane Hookom]

You can't Sum() a control. It just doesn't work.

You can create a running sum on the text box or an exact duplicate (set to
invisible) of the text box. If the invisible text box is named
txtRunningSum, then add a text box to the report footer with a control
source of:
=txtRunningSum

--
Duane Hookom
MS Access MVP
--

What do you want to do with the sum? is it something in a report or group
or
page footer?
You can sum an unbound text box. Just make the control source
= sum([NoSchools])

I have an unbound text box, called [NoSchools] in the detail section of a
report that gets it's data from Select Case statements in the onprint
event .
I want to be able to find the sum of the numbers in this text box, but
can't
because it is an unbound text box in a report. The report is based upon a
query.

Any help will be appreciated.

- Steve