Funny issue when trying to sum the total of 2 fields on a third field.

[Villarreal68]

Hello everyone,

I've tried many things (compact and repair, Nz(,0), sum()) and I can't get it to work. I entered =[field1]+[field2] but it behaves like if I had entered =[Field1] & [Field2]. Yes instead of adding the numbers it just puts them together. For example: Field1=3 and Field2=5 instead of field3=8 it shows Field3=35.

Any one has any advice on this?

Thank you!

René

 

[pbaldy]

One or both of the fields must be seen as text. Try

=CCur([field1])+CCur([field2])

 

[Villarreal68]

One or both of the fields must be seen as text. Try

=CCur([field1])+CCur([field2])

Thank you Pbaldy!!!!! This was driving me insane! Question: How can I force the fields to NOT be seen as text, but rather number fields?

Thanks again!

Edit: Got it! I manually changed all fields to "General Number " format and that did it without the CCur. Thanks for your help Pbaldy!

 

[pbaldy]

Happy to help! The first option is making sure the data type in the table is numeric rather than text. Failing that, you're looking at applying a conversion function somewhere along the line.