473,320 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Sum of 2 Text Boxes

132 100+
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("*","EMHS New Closed Appeals Preview")
Feb 27 '08 #1
7 6897
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("*","EMHS New Closed Appeals Preview")

try this...

=sum(Count([Case]) ,DCount("*","EMHS New Closed Appeals Preview")
Feb 28 '08 #2
NeoPa
32,556 Expert Mod 16PB
You don't share much info, but in TextBoxC you could have :
Expand|Select|Wrap|Line Numbers
  1. =[TextBoxA] + [TextBoxB]
Feb 28 '08 #3
Proaccesspro
132 100+
You don't share much info, but in TextBoxC you could have :
Expand|Select|Wrap|Line Numbers
  1. =[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("*","EMHS 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???
Mar 3 '08 #4
JKing
1,206 Expert 1GB
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("*","EMHS 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.
Mar 3 '08 #5
JKing
1,206 Expert 1GB
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?
Mar 3 '08 #6
Proaccesspro
132 100+
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.
Mar 3 '08 #7
NeoPa
32,556 Expert Mod 16PB
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("*","EMHS 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.
Mar 3 '08 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Dan | last post by:
Can anyone offer suggestions on how to do this or if it is possible? I have a form that uses a drop down box and 2 text fields. What I am trying to do is have the value of each text box set by...
7
by: Gertjan van Heijst | last post by:
Hi, I really hope someone can help me because I've already spend 2 days on this problem and I'm not getting anywhere. I think the problem is that I don't really understand how text boxes store...
2
by: John Kreps | last post by:
(acc 2002) I've got six unbound text boxes on a subform that has a white background. Each of those six boxes has an expression that when true, will change its background from white to another...
2
by: Gary | last post by:
Hello All, I have an editable data grid in my web form, this grid allows the user to add new records, edit existing records and also delete them. When a user adds a record the grid goes in to...
11
by: Edson Peacock | last post by:
I have a report with sub reports, one of the subreports have 12 text boxes that are 2" high and I want them all to grow if one goes to 3" high. If anyone has any suggestions they are very much...
6
by: BurntWithTime | last post by:
Hello everyone, Please can anyone tell me if it is possible for a VB.NET application to check a database and then create textboxes on a form that correspond to those records on the database? For...
4
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post by:
I have created a report. This report needs to display records between two dates entered by the user. I put two text boxes on the report so I can enter the start and end date - I set them to use an...
6
by: =?Utf-8?B?Sm9obiBBdXN0aW4=?= | last post by:
I have an app that displays about 20 items of data in text boxes. Very occasionally I need to allow these to be used for data entry, but the bulk of the time they are solely for information. They...
6
by: noe1818 via AccessMonster.com | last post by:
Just a quick question about lines: Is it possible to connect a text box (e.g. txtbx1 to txtbx2 and txtbx2 to txtbx3) with lines where txtbx1,2,&3 move up or down according to their values? Like...
11
by: jwessner | last post by:
I have a form (Form1) which contains basic Project data and a subform listing the personnel assigned to the Project as a continuous form. Selecting a person on that project and clicking on a command...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.