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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!