I have a form with three text boxes on it. I want the third text box
to show the total of the values in the other two text boxes.
The first box is named: BoxOne and I type the number 2 into it
The second box is named: BoxTwo and I type the number 3 into it
If the third box is named: TotalBox
and the control source for the TotalBox reads, =([BoxOne]+[BoxTwo])
the value in the total box is 23, not 5
It just places the two separate values side-by-side in the totalbox.
If I use =([BoxOne]*[BoxTwo])
then I get 6 (two TIMES three) I tried using sum in various ways
but I just got error messages. Can anyone help with this. 5 7650
"+" is both an arithmetic and a string operator. As a string operator, it
concatenates the two values. This is what you are seeing! Access thinks Box1 and
Box2 in the expression in the control source are both strings so it concatenates
to get 23. Format Box1 and Box2 as number and you will get the arithmetic
operation you want in the TotalBox.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"RC" <rc*********@ya hoo.com> wrote in message
news:3c******** *************** ***@posting.goo gle.com... I have a form with three text boxes on it. I want the third text box to show the total of the values in the other two text boxes. The first box is named: BoxOne and I type the number 2 into it The second box is named: BoxTwo and I type the number 3 into it If the third box is named: TotalBox and the control source for the TotalBox reads, =([BoxOne]+[BoxTwo]) the value in the total box is 23, not 5 It just places the two separate values side-by-side in the totalbox. If I use =([BoxOne]*[BoxTwo]) then I get 6 (two TIMES three) I tried using sum in various ways but I just got error messages. Can anyone help with this.
On 15 May 2004 11:42:32 -0700, RC wrote: I have a form with three text boxes on it. I want the third text box to show the total of the values in the other two text boxes. The first box is named: BoxOne and I type the number 2 into it The second box is named: BoxTwo and I type the number 3 into it If the third box is named: TotalBox and the control source for the TotalBox reads, =([BoxOne]+[BoxTwo]) the value in the total box is 23, not 5 It just places the two separate values side-by-side in the totalbox. If I use =([BoxOne]*[BoxTwo]) then I get 6 (two TIMES three) I tried using sum in various ways but I just got error messages. Can anyone help with this.
Access is treating the entries as though they were Text, not numbers.
Set the Format property of each of the controls to General Number (or
any of the other Number Formats, i.e. Fixed, Standard, etc.).
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Sounds like you have either the fields in the table or the boxes on
the form set to text and not number. rc*********@yah oo.com (RC) wrote in message news:<3c******* *************** ****@posting.go ogle.com>... I have a form with three text boxes on it. I want the third text box to show the total of the values in the other two text boxes. The first box is named: BoxOne and I type the number 2 into it The second box is named: BoxTwo and I type the number 3 into it If the third box is named: TotalBox and the control source for the TotalBox reads, =([BoxOne]+[BoxTwo]) the value in the total box is 23, not 5 It just places the two separate values side-by-side in the totalbox. If I use =([BoxOne]*[BoxTwo]) then I get 6 (two TIMES three) I tried using sum in various ways but I just got error messages. Can anyone help with this.
THANK YOU! Thank You, Thank You. I wasted so much time on this one.
I was sure the syntax to get the total was correct, that's why I kept
trying. I finally gave up and asked you all. I set the Format
property for the text box to General Number and everthing was fine.
Thank all of you so much for the help, now I can move on instead of
being stuck. ma********@yaho o.co.uk (Charlie) wrote in message news:<42******* *************** ***@posting.goo gle.com>... Sounds like you have either the fields in the table or the boxes on the form set to text and not number.
rc*********@yah oo.com (RC) wrote in message news:<3c******* *************** ****@posting.go ogle.com>... I have a form with three text boxes on it. I want the third text box to show the total of the values in the other two text boxes. The first box is named: BoxOne and I type the number 2 into it The second box is named: BoxTwo and I type the number 3 into it If the third box is named: TotalBox and the control source for the TotalBox reads, =([BoxOne]+[BoxTwo]) the value in the total box is 23, not 5 It just places the two separate values side-by-side in the totalbox. If I use =([BoxOne]*[BoxTwo]) then I get 6 (two TIMES three) I tried using sum in various ways but I just got error messages. Can anyone help with this.
RC,
If you ever decide to look for paid assistance, contact me at the email address
below. I am in business to provide customers with a resource for help with
Microsoft Access, Excel and Word applications. You can view my website at www.pcdatasheet.com.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"RC" <rc*********@ya hoo.com> wrote in message
news:3c******** *************** ***@posting.goo gle.com... THANK YOU! Thank You, Thank You. I wasted so much time on this one. I was sure the syntax to get the total was correct, that's why I kept trying. I finally gave up and asked you all. I set the Format property for the text box to General Number and everthing was fine. Thank all of you so much for the help, now I can move on instead of being stuck.
ma********@yaho o.co.uk (Charlie) wrote in message
news:<42******* *************** ***@posting.goo gle.com>... Sounds like you have either the fields in the table or the boxes on the form set to text and not number.
rc*********@yah oo.com (RC) wrote in message
news:<3c******* *************** ****@posting.go ogle.com>... I have a form with three text boxes on it. I want the third text box to show the total of the values in the other two text boxes. The first box is named: BoxOne and I type the number 2 into it The second box is named: BoxTwo and I type the number 3 into it If the third box is named: TotalBox and the control source for the TotalBox reads, =([BoxOne]+[BoxTwo]) the value in the total box is 23, not 5 It just places the two separate values side-by-side in the totalbox. If I use =([BoxOne]*[BoxTwo]) then I get 6 (two TIMES three) I tried using sum in various ways but I just got error messages. Can anyone help with this. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: beavenour |
last post by:
I am looking for some help creating a more universal function out of
this lame attempt at javascript. I have little experience with
javascript and want to be able to universalize this function. So how
do I change this script so that I can call any field or any number of
fields to be totaled? For example - calculate(myfield01, myfield02)
at one total field and calculate(myfield06, myfield08, myfield11) at
another total field instead of...
|
by: kie |
last post by:
hello,
i have a table that creates and deletes rows dynamically using
createElement, appendChild, removeChild.
when i have added the required amount of rows and input my data, i
would like to calculate the totals in each row.
when i try however, i receive the error:
"Error: 'elements' is null or not an object"
|
by: James Greig |
last post by:
hello people,
i'm just learning javascript, could someone point me in the direction
of an example of the following, or give me some clues as to how it
might be done:
what i would like to do is make a self totalling version of this page
> http://www.ayrshirehousing.org.uk/applications/applications.html
so that basically as a person checked or unchecked boxes, a
|
by: strsury |
last post by:
Hi all,
I have a page with 5 or 6 drop down boxes, all ranging from 1 to 100.
After each is selected, I need a box that will show a total of all the
results.
So basically, dropdown 1 + dropdown 2 + dropdown 3 = box.
A thousand bonus points if someone can tell me how to make sure the box
|
by: zaiena |
last post by:
hi
how to calculate the total average for many text boxes values in the same form
for example i have three text boxes two in the main form and the last one in the sub form so when the user define the value for the text box in the subform and the value for one of the text boxes in the main form the last one will automatically toke it's value which depends on the other two text boxes.
it's not matter what exactly the operation i just need the...
| |
by: aman909 |
last post by:
Hi,
I would like to calculate the total on a form. But the problem is that i need it to calculate from 5 text boxes on a form, but not all this text boxes are filled out depending on a client.
E.g. one client will have 3 out of the 5 text boxes filled out while another will only have 1 out the 5. So i need to be able to work out the total, but the text boxes that aint filled out have to stay empty it cant contain a 0, zero.
what is the...
|
by: sammiesue |
last post by:
Hi,
I have form with 2 autosummed textboxes ("total" and "casinototal"). I would like to have a grand total textbox ("grandtotal") get its value from summing "total" and "casinototal", but it doesn't seem to be working. Here is my code. Thanks for your help.
-sammie
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Nursing Conference 2007 Registration Form</title>
|
by: richbneal |
last post by:
I really like the site so far and this is my first post. I have looked through some of the archives with no luck. I have also read the posting guidelines and will do my best to be clear and accurate with my problem. I am working with Access 2k / Win 2k. I have some experience and must have this figured out before Aug1.
What i am tasked with is to modify an existing process that calculates the hours and minutes worked, which is entered on a...
|
by: dablyz |
last post by:
Hi!
I was wondering if I could get some more excellent advice from this site. I'm designing a project that ultimately, among other functions, calculates a download time based upon a file size (which is loaded at run time by the user), a specified percentile of compression (selected by the user - 0-10%) and a download rate numerical up down box (also user specified - 1-10kb/s).
I figured that this just might be a glorified version of a VAT...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |