Summing unbound text box in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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])
 
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
--

Klatuu said:
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])

Steve Albert said:
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
Click to expand...
Click to expand...
 
Back
Top