Table General Number Column - Decimal doesn't work

[Dormie]

Hi,

I have a couple of tables with general number columns. They don't seem to accept a decimal point for example 100.1, it keeps reverting back to 100. Is there a way around this?

Thank you!

[June7]

Change the field data type to Number - Double.

[Dormie]

Great, That was easy. Sorry, I should have found that right in front of me. I have numbers in the thousands and it's created a comma in the column. Can I get rid of the comma?

[June7]

The comma probably isn't really in the data. I assume it is just a setting of the Format property.

[Vintner]

I'm having the same issue with a number field rounding up or down to the nearest whole number. (ex. 5.4 rounds to 5.0, 5.6 rounds to 6.0) I'm using Access 2013 and did see in a prior post to set the field to Number - Double. I have the field set to number but cannot figure out how to set to double.

[June7]

Table in design view, select the field you want to modify, look at the properties below the field list. Change the FieldSize to Double.

[Dormie]

This did work perfectly for me.

Once you go into design view (which is right click on the top tab on the table). I have my coloumn set to format: general number, field size: single, decimal places: 1.

Not exactly what I said I did in the my last post.

Thank you again for your always quick and accurate responses June7!

[June7]

I always use Double, never Single.