help with totals for count text boxes

[gacapp]

I am a novice, so I'm sure (hoping) someone can help.



I have 5 text boxes that have count totals and I used the code below:

=DCount("*", "TableName", "[Gender]='male' AND ([Age] >= 21 OR [Age] <= 30)")

This code works fine.

What I need is a text box that will come up with the sum of all five boxes. So for example, I have 5 count text boxes that have the numbers (2,4,3,5,4) in them. I need one text box that will sum the total of all 5 count text boxes (20).

Can someone show me the code for doing that??

Any help would be appreciated.

[RuralGuy]

ControlSource of:
=Me.txt1 + Me.txt2 + Me.txt3 + Me.txt4 + Me.txt5
...using your ControlNames of course.

[gacapp]

Maybe I did something wrong.

My text boxes are named text19, text20, text21, text22 and text23.

I put in the Control Source for data:
=Me.text19+Me.text21+Me.text22+Me.text23+Me.text24

and it gives me the #Name? response.

Can you elaborate a little more??

thanks

[RuralGuy]

Did you intend to miss text20 and add text24?

[gacapp]

Yes, the text boxes that I listed are correct.

any Ideas??

[RuralGuy]

Maybe I did something wrong.

My text boxes are named text19, text20, text21, text22 and text23.

I put in the Control Source for data:
=Me.text19+Me.text21+Me.text22+Me.text23+Me.text24

and it gives me the #Name? response.

Can you elaborate a little more??

thanks

You have an inconsistancy in the names of your TextBoxes and your formula. Start with =Me.text19
If that works then add =Me.text19+Me.text20
...etc...

[gacapp]

I tired =Me.Text19 and it gives me the same error.

The controlsource for the Text19 box is:

=DCount("*","Age Group: New-Child <1")

which grabs the amount of kids that are under 1 year old. That works correctly.

So any other suggestions??

[RuralGuy]

I take it "Age Group: New-Child <1" is the name of one of your queries.
Try =Text19 as a ControlSource
...what is the name of the control where you are trying to sum everything?

[gacapp]

your suggestion worked - thank you very much

[RuralGuy]

So the solution is to drop the Me. from the reference right?
=txt1 + txt2 + txt3 + txt4 + txt5
Is this thread ready for the Solved thread tool?

[gacapp]

Yes the solution was to drop the "Me".

This is a solved thread