Add operator not working as expected

[g4b3TehDalek]

Hello AF ,

Not quite sure what's going on with this. I'm trying to add several fields together in a query but instead of getting a sum I'm getting a huge number consisting of combined values.

For example, when I add:
57,569 + 500 + 1,000 + 500 + 3,200 + 7,157 + 3,700 + 1,000 + 10,881

I get:
575,695,001,000,500,320,071,573,700,100,010,881

And the expression I'm using is:


Annual: FormatNumber([BaseSalary]+[BCLADReturn]+[MAReturn]+[RSPReturn]+[OtherStipend]+[AcaCoach]+[Sierra]+[LongevityStipend]+[HealthCostsReturn],0)

I've run into this problem before on a form I created for this same database, but luckily the problem resolved itself that time. Not so fortunate this time around.

I'm not sure if this is contributing to the problem, but all of the fields (except one) I'm adding are calculated. I've even excluded the non-calculated field and get the same result.

Help plzzz

[pbaldy]

The values are being seen as text rather than numbers, either due to their data type in the table or as the result of a function being applied during the calculation (IIf, Nz, etc). You can try wrapping each in the appropriate conversion function (CLng, CCur, etc).

[g4b3TehDalek]

Thx Paul. I kinda suspected that but wasn't sure how to approach it. I'll punch in some conversions and cross my fingers

[g4b3TehDalek]

I'd like to hereby nominate pbaldy for the Nobel Prize!

It worked perfectly Paul. As ur suggestions always seem to.

Thx a million.

[pbaldy]

LOL! Happy to help.