var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: help with totals for count text boxes
I have a report that has 5 text boxes that has controlsource count formulas like this:
=DCount("*","Age Group: New-Child <1")
these count boxes work fine. The five count boxes have counts of (5,3,4,2,5). The names of the text boxes are Text19, Text20, Text21, etc.
What I need is a text box that will give me the total of those 5 count boxes. So the number in the text box should be 19.
Someone suggested to use:
However this did not work.
Any ideas of how I can create a text box that that total count text boxes?
Any help would be appreciated
As noted elsewhere, Me is invalid outside VBA. Try
thank you very much - your solution worked!!
No problem, and welcome to the site by the way.