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.