Text box that adds two other together !!

[prodtest]

Hi,
This seemed such an easy thing to do after working with MDB files for so long !!
Basically I have a form that shows results from a sql database, the problem I have is it shows two boxes 'tested' and 'untested'.
Now I thought it would be easy to add another unbound text box that would simple add the two together using the formula "= [tested]+[untested]"
This turns out not to be the case, as I end up with the result " 10 10" (10 being the value in the tested column and 10 in the untested column).

Can any one point out where I am going wrong ?

Cheers

Ben

 

[ItIsHardToProgram]

It is probably Your type of value hence a string, that messes up ur results.... try it as a number. but, you should continue this thread in forum702, more people could help you probably.