table rounding off number

[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

 

[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

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.