decimal problem

[Christopher Brandsdal]

Hi!

I hav set up a table in access with a few fields. One of them is set up with
currency and 6 decimals.
But when I type in data directly into the table, it rounds of to 4 decimals!
Why? Any help on this problem?

Best regards,
Christopher Brandsdal

 

[Guest]

That's correct.

From Help:
Currency values and numeric data used in mathematical calculations involving
data with one to four decimal places. Accurate to 15 digits on the left side
of the decimal separator and to 4 digits on the right side.

It probably muddies the water that the "Decimal Places" property lets you
enter a value of up to 15, which might give the impression that that can
override the limitations of the Currency data type. Anything past 4 is
ignored.

You would probably do better to use the Number data type, with the Field
Size set to Single, and Decimal Places set to 6. (Single allows a precision
up to 7.)

Hope that helps!

David

 

[Jeff Boyce]

Assuming you need 6 places of precision, David's response offers a solution.
If you don't need that level of precision, and 4 places would do, use
Currency data type.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Christopher Brandsdal]

That's correct.

From Help:
Currency values and numeric data used in mathematical calculations
involving
data with one to four decimal places. Accurate to 15 digits on the left
side
of the decimal separator and to 4 digits on the right side.

It probably muddies the water that the "Decimal Places" property lets you
enter a value of up to 15, which might give the impression that that can
override the limitations of the Currency data type. Anything past 4 is
ignored.

Have to say this is kinda strange. Why make the option? lol

You would probably do better to use the Number data type, with the Field
Size set to Single, and Decimal Places set to 6. (Single allows a
precision
up to 7.)

Hope that helps!

David

Just what I needed! Thanks a lot!