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?

[Missinglinq]

...If i set it as a Number it keeps rounding up...

What kind of FieldSize did you use when defining the Fields? The default is Integer, and Access will always change numbers containing decimals into whole numbers. If this is the case, change the FieldSize to either Single or Double, depending on your needs. If, in Table Design, you select a Number Field, place the cursor in the FieldSize box and hit <F1> help will pop up explaining the different types of Numbers and their ranges.

Linq ;0)>

[keiath]

Thanks that seem to have solved the problem

[Missinglinq]

Glad we could help!

Linq ;0)>