Access decimal setting doesn't show digits to the right of the .

[Vicki47]

I have created a table in ACCESS 2007 using the decimal field size. No
matter what precision or decimal places setting I use, the digits to the
right of the decimal point do not display either in table view or if I run a
Query with select * from the table.

 

[Tom Lake]

I have created a table in ACCESS 2007 using the decimal field size. No
matter what precision or decimal places setting I use, the digits to the
right of the decimal point do not display either in table view or if I run
a
Query with select * from the table.

What number type did you use? The default is Integer which won't show
decimal places.

Tom Lake