Working with decimal places in Access 2000

[Jill]

I am trying to keep track of numbers with decimal places.
However, when I enter the information the numbers keep
rounding up. I am sure there is a way to keep track of
information that needs to be maintained to the hundredth.
Is there anything I can do to the table setup that will
fix this problem. If anyone has any advice I would greatly
appreciate it. Thanks!

 

[Douglas J. Steele]

One of the most common mistakes is forgetting to change the Field Size from
the default Long Integer when you make a field's Data Type Number. Only
Field Sizes of Single or Double can accept decimal points.

 

[Guest]

Thank You!

-----Original Message-----
One of the most common mistakes is forgetting to change the Field Size from
the default Long Integer when you make a field's Data Type Number. Only
Field Sizes of Single or Double can accept decimal points.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)






.