Calculation Combining Fields, Not Adding
Hello,
This should be really simple. I have 3 fields that calculate correctly on a form and insert the calcuation into a table. (I know, NEVER store a calcuated value, but I have a reason for doing it.)
Now I'm trying to add those 3 fields and am getting an incorrect sum. Here is my string:
Me.Total_Man_Hours_Text = Nz([Total_Man_Hours_Calc_Field_1], 0) + Nz([Total_Man_Hours_Calc_Field_2], 0) + Nz([Total_Man_Hours_Calc_Field_3], 0)
When field "1" equals 11, field "2" equals 0, and field "3" equals 0, I am getting a sum of 1100. So it's combining the 11, 0, and 0. Anyone?
This should be really simple. I have 3 fields that calculate correctly on a form and insert the calcuation into a table. (I know, NEVER store a calcuated value, but I have a reason for doing it.)
Now I'm trying to add those 3 fields and am getting an incorrect sum. Here is my string:
Me.Total_Man_Hours_Text = Nz([Total_Man_Hours_Calc_Field_1], 0) + Nz([Total_Man_Hours_Calc_Field_2], 0) + Nz([Total_Man_Hours_Calc_Field_3], 0)
When field "1" equals 11, field "2" equals 0, and field "3" equals 0, I am getting a sum of 1100. So it's combining the 11, 0, and 0. Anyone?
ASKED:
Jul 25, 2008 9:39 PM GMT
UPDATED:
July 28, 2008 2:02:37 PM GMT
Answer Wiki:
it is taking them as text rather than taking them as numeric. so instead of governing a mathematical addition of 11+0+0 = 11, it is adding it as text - '11' + '0+ '0' = 1100
you have to convert these fields to numeric first. or convert text to number in your formula while addition.
you have to convert these fields to numeric first. or convert text to number in your formula while addition.
8,200 pts.
To see other answers submitted to the Answer Wiki View Answer History.
