Add values on a form

[paulcraigdainty]

I need to be able to add up and display the total of a number of values.

My thinking was to use an expression behind a txtbox as follows:

=([S1])+([s2])

The value of S1 is 100 and the value of S2 is 50

My expression doesn't seem to add the values it just displays them like this:

10050

I want the expression to total the values and display 150.

What do I need to do to my expression to total the values?

 

[David Eagar]

Are fields [S1] and [S2] defined as numbers? Your result suggests they are formatted as Text

 

[paulcraigdainty]

Yes my fields wern't defined as numbers. I have now changed the field type in the table and this has corrected the problem.

Many thanks !