Ok. So this should really be simple but for some reason, I am not getting the result I want.
I have the following fields:
Incomplete: Nz([Incomp],0) - my original field name was "Incomp". I renamed it to Incomplete and defaulted it to zero.
Complete: Nz([com],0) - my original field name was "com". I renamed it to Complete and defaulted it to zero.
I am trying to create a new field that will be a sum of the two above fields. This is what is entered in my field: Possible Total: [Incomplete]+[Complete].
For example sake, lets say I have a zero in Incomplete and a 4 in Complete. One would think my result would be 4 (i.e. 0+4=4). But no, my result is 04 (like it concatenated them together).
Another example, Incomplete=2 and Complete=29. My result should be 31. My actual result is 229.
Thoughts?
I have the following fields:
Incomplete: Nz([Incomp],0) - my original field name was "Incomp". I renamed it to Incomplete and defaulted it to zero.
Complete: Nz([com],0) - my original field name was "com". I renamed it to Complete and defaulted it to zero.
I am trying to create a new field that will be a sum of the two above fields. This is what is entered in my field: Possible Total: [Incomplete]+[Complete].
For example sake, lets say I have a zero in Incomplete and a 4 in Complete. One would think my result would be 4 (i.e. 0+4=4). But no, my result is 04 (like it concatenated them together).
Another example, Incomplete=2 and Complete=29. My result should be 31. My actual result is 229.
Thoughts?