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

  • Thread starter Thread starter Vicki47
  • Start date Start date
V

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.
 
Vicki47 said:
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.
Click to expand...

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

Tom Lake
 
Back
Top