Preventing numbers from rounding up to the nearest whole number

[joce]

Hi,

I have several fields with combo box answers each answer being 3 digits long e.g. 3.25 and 2.25. I have the field data type to text for all the fields.

Will this have any effect when I am trying to carry out calculations.

Currently my expressions i am using to total these figures up and find the average isn't working. And along with this, they keep rounding up to whole numbers qwhen entered into the form which I dont want them to do. Even when i did change it to a number data type field and set it to having 2 decimal places, the numbers still remained to round themselves up.

Can anyone help at all here??

Thanks

Joce

 

[DJkarl]

If you are trying to do calculations do not use a text field data type, it should be numeric. Secondly if you have decimal places the datatype should be double or currency depending on your needs.

 

[joce]

But when i change my datatype to currency, i end up with currency signs e.g.£ but I dont want these because ti isnt currency I am working with?

 

[vbaInet]

But when i change my datatype to currency, i end up with currency signs e.g.£ but I dont want these because ti isnt currency I am working with?

DJKarl stated (note the blue bit):

If you are trying to do calculations do not use a text field data type, it should be numeric. Secondly if you have decimal places the datatype should be double or currency depending on your needs.

Data type: Number
Field Size: Double (that's what he meant).