Calculations on a form

  • Thread starter Thread starter Sharon
  • Start date Start date
S

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
 
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).
Click to expand...

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!
 
Back
Top