Allow 2 decimal places

[Roxy]

I need to set up a simple table in which I am keeping
track of height and weight out to 2 decimal places. What
do I fill in design view after selecting number as the
Data type?

Selecting Decimal for Field Size and general Number for
Format and 2 for Decimal Places doesn't allow decimals to
be displayed in the table. It rounds up the number.

Thanks in advance!

 

[Ken Snell [MVP]]

The Scale property must be changed to how many decimals places are to be
stored in the field. It defaults to 0.

However, may I recommend that you not use Decimal type. It's somewhat buggy.
I think Single will work better for your needs, and then the decimal places
property will work as you anticipate.

 

[Roxy]

Great advice. thanks.

-----Original Message-----
The Scale property must be changed to how many decimals places are to be
stored in the field. It defaults to 0.

However, may I recommend that you not use Decimal type. It's somewhat buggy.
I think Single will work better for your needs, and then the decimal places
property will work as you anticipate.

--

Ken Snell
<MS ACCESS MVP>




.