decimal places

  • Thread starter Thread starter andrew
  • Start date Start date
A

andrew

Hello all!
I'm trying to get my table to show decimal values.

In the table design view, I set "Field Size" to decimal,
and Decimal Places to "4". However, all the decimal
values I enter still get truncated.

The help section said to look at the "Property Sheet."
This is the property sheet, right?

Thanks in advance!
Andrew
 
Hello all!
I'm trying to get my table to show decimal values.

In the table design view, I set "Field Size" to decimal,
and Decimal Places to "4". However, all the decimal
values I enter still get truncated.

The help section said to look at the "Property Sheet."
This is the property sheet, right?
Click to expand...

Look first at the top row of the property sheet. I suspect it has the
default Number datatype, Long Integer. An integer, BY DEFINITION, is a
whole number.

Change it to Float or Double. I don't recommend using the Decimal
datatype, it's buggy. If you need exactly four (no more, no fewer)
decimal places, don't use a Number datatype at all - use a Currency
datatype instead.
 
Back
Top