Calculations on a form

[Sharon]

Hello -
I have a form in which I'd like to calculate the total of
3 text boxes into a 4th. However, it doesn't want to
work. When I do the expression =[Amount#1]+[Amount#2]+
[Amount#3], it just gives me the amounts in succession.
For example:
Amount#1=$10,000
Amount#2=$20,000
Amount#3=$30,000
The field shows the following: 100002000030000 instead of
the value I was trying to calculate (60,000).

When doing =[Amount#1]+1 - it works fine.. any help anyone
can offer would be so appreciated.

Thanks -
Sharon

 

[John Vinson]

Hello -
I have a form in which I'd like to calculate the total of
3 text boxes into a 4th. However, it doesn't want to
work. When I do the expression =[Amount#1]+[Amount#2]+
[Amount#3], it just gives me the amounts in succession.
For example:
Amount#1=$10,000
Amount#2=$20,000
Amount#3=$30,000
The field shows the following: 100002000030000 instead of
the value I was trying to calculate (60,000).

What are the Control Source properties of the three Amount fields?
What datatype is the underlying field? It sounds like either the field
type is Text, or you're using the Format() function which turns
numbers into text strings.

Try

Val([Amount#1]) + Val([Amount#2]) + Val([Amount#3])

but it would be better to figure out the underlying problem!

 

[tom]

Make sure your fields are formatted as currency...

HTH.

Tom.