Decimal Places Question

[commandolomo]

G'day everyone

A rather rudimentary question, but has continued to confound me!

I have got a form based upon a table, and all I want to do is to input numbers as decimals. Currently, whether, I enter the number in the table or in the form, it automatically rounds up or down the number to the nearest whole number - for example, when I enter 10.25 it enters it as 10, 10.6 enters as 11. I only need to 2 decimal places.

It does enter as decimals if the Data Type properties in the table is set to text, but I am also extracting the db data into Excel, and if the Data Type is set to text, and numbers are entered, when extracted into Excel the numbers do not sum! O the joy of Microsoft!!!

So, I have to set the Data Type as Number. I have tried various combinations of setting the properties and formatting on both the table and the text boxes on the forms, but to no avail.

Would anyone know the correct properties to set numbers so that they appear only as I enter them?

Thanks in advance

 

[EMP]

In table Design, set Data Type as Number

And in the General Tab, select
Field Size: Single
Format: Fixed

See image attached.

 

[commandolomo]

Many thanks, sorted!