text and numbers

How do I? I have two fields in a table, field#1 (2)and field#2 (4)They both have a datatype of text. However when i want to add or substract the values of these two fields together in field#3(data type number) i get an error. How can i get around this problem.

ie.. i get 2 + 4 = 24 I SHOULD GET 2 + 4 = 6

i realize that i can't add two text values together. I would need to convert the text values into numbers.

[Bigley]

Use the expression Val or CInt -

total = Val(txtOne) + Val(txtTwo)

[_bman_]

try cint(field#1) + cint(field2) = field3

because field1 and field2 are text adding them together is like combining them - thus 2 + 4 = 24, 4 + 2 = 42

[karunakaran]

Hai,
Since your datatype is text you can not add just like that.
You should convert into interger or double.
so before your calcultation you convert into interger if your values are in the integer limit.use Cint function.
If not simply use Val function.it will converts into double.or use CDbl function.


thanks
karun