table rounding off number

O

oxicottin

Hello, I made a table I need to put number in which represents inches and it
keeps rounding my numbers off. Example: 6.9 it rounds to 7

How do I fix this?

Thanks,
Chad
 
F

fredg

Hello, I made a table I need to put number in which represents inches and it
keeps rounding my numbers off. Example: 6.9 it rounds to 7

How do I fix this?

Thanks,
Chad
Click to expand...

Most likely you set the Field's Datatype to Number and It's field Size
property to Integer or Long Integer. By definition, an Integer cannot
have a decimal value. Either change the Datatype to Currency, or
change the Field Size to Double.
 
Top