Sum of 2 Text Boxes

[Proaccesspro]

I have to text boxes that have a different control source. Can I ADD the values of each text box?? I'm guessing the code to be something like:

=sum(Count([Case]) & DCount("*","EMH S New Closed Appeals Preview")

[talllight]

I have to text boxes that have a different control source. Can I ADD the values of each text box?? I'm guessing the code to be something like:

=sum(Count([Case]) & DCount("*","EMH S New Closed Appeals Preview")

try this...

=sum(Count([Case]) ,DCount("*","EM HS New Closed Appeals Preview")

[NeoPa]

You don't share much info, but in TextBoxC you could have :

=[TextBoxA] + [TextBoxB]

[Proaccesspro]

You don't share much info, but in TextBoxC you could have :

=[TextBoxA] + [TextBoxB]

I tried that intially, but no cigar......I have 2 text boxes in a report that I need to sum. The first text box has a control source of =Count([Case]), the second has a control source of =DCount("*","EM HS New Closed Appeals Preview")
When I use [txtbox3] =[txtbox1] + [txtbox2], NO Value appears on the report.....

Another issue I have is how can I store the value of textbox3 for future use ??

Lastly, I have yet another text box that is tied to a select query. When run, the query would return a count BY item. For example

Letters in Review 2
Phone Calle Made 4
Legal Review 6

I am trying to stuff the ENTIRE result of the query into a text box. When I run the report, it asks me for a parameter value. I'm guessing the parameter value it is looking for is the type of item, i.e.Phone Call, or Legal Review, etc...Is there another whay to do this?? Also, would the text box grow and shrink with the number of rows the query returns???

[JKing]

I tried that intially, but no cigar......I have 2 text boxes in a report that I need to sum. The first text box has a control source of =Count([Case]), the second has a control source of =DCount("*","EM HS New Closed Appeals Preview")
When I use [txtbox3] =[txtbox1] + [txtbox2], NO Value appears on the report.....

Another issue I have is how can I store the value of textbox3 for future use ??

What is your report based off of?

I'm hoping and assuming it's based off a query. If this is the case why not just sum the two fields in the query? Then you will have a brand new field that you can place on your report with the correct value. This will also allow you to retrieve the value for future use i.e. other reports or forms.

[JKing]

Lastly, I have yet another text box that is tied to a select query. When run, the query would return a count BY item. For example

Letters in Review 2
Phone Calle Made 4
Legal Review 6

I am trying to stuff the ENTIRE result of the query into a text box. When I run the report, it asks me for a parameter value. I'm guessing the parameter value it is looking for is the type of item, i.e.Phone Call, or Legal Review, etc...Is there another whay to do this?? Also, would the text box grow and shrink with the number of rows the query returns???

Instead of cramming all that info into a textbox, why not use a subreport?

[Proaccesspro]

Instead of cramming all that info into a textbox, why not use a subreport?

Yes, the text boxes are based off queries....Not sure that would solve my problem because I still need to sum the values of seperate textboxes stemming from multiple querues.

[NeoPa]

I tried that intially, but no cigar......I have 2 text boxes in a report that I need to sum. The first text box has a control source of =Count([Case]), the second has a control source of =DCount("*","EM HS New Closed Appeals Preview")
When I use [txtbox3] =[txtbox1] + [txtbox2], NO Value appears on the report.....

Where are the text boxes included in your report?
Are they in the same section? Are any in headers or footers?

Another issue I have is how can I store the value of textbox3 for future use ??

Lastly, I have yet another text box that is tied to a select query. When run, the query would return a count BY item. For example

Letters in Review 2
Phone Calle Made 4
Legal Review 6

I am trying to stuff the ENTIRE result of the query into a text box. When I run the report, it asks me for a parameter value. I'm guessing the parameter value it is looking for is the type of item, i.e.Phone Call, or Legal Review, etc...Is there another whay to do this?? Also, would the text box grow and shrink with the number of rows the query returns???

Please post these in another thread.
Separate issues - separate threads.

Admin.