CODEWITHSUNDEEP
ms-accessrounding
user3625292
user3625292

Reputation: 1

Access 2007 unwanted rounding off numbers

I have an access 2007 table with a number field. Properties are Long Integer/general number/2 decimal places. My problem is that when I enter a decimal value it is being rounded off. I have tried other field sizes and other formats but I cannot get the decimal value to show.

Upvotes: 0

Views: 92

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300719

A "Long Integer" cannot have decimal places....

Use

NUMBER (FieldSize= DOUBLE) or NUMERIC

See Microsoft Access Data Types

Or as @ Gord Thompson points out, perhaps the Currency datatype is a closer match to your needs?

Upvotes: 1

Related Questions