Sum on a tab from a table Sum Problem

[Keiath]

I have a table that has fields for number input

On my form I have in a TAB form 3 fields to input a figure, in the table these are set up as a Text NOT a Number. If i set it as a Number it keeps rounding up? even after i enforce 2 decimal places it still keeps rounding up.

Field 1 - 42988.62
Field 2 - 0.00
Field 3 - -14330.84

I then created a unbound txtbox so I can add these up

=[ResBF]+[ResRefReC]+[ResSurDef]

what i get in return is this :- 42988.620.00-14330.84

I also tried =Sum([ResBF]+[ResRefReC]+[ResSurDef])

and that just comes up with #Error

I even tried in the table directly to have a calculated field and still having the same problems

I have no idea whats going on here, any ideas?

 

[pbaldy]

They should have a numeric data type if you want to do math. Regarding rounding, make sure you didn't use Integer or Long Integer in Field Size. Try Currency as the data type.

 

[Keiath]

Thank I did finally realize my mistake

 

[pbaldy]

No problem.