i'm trying to get the decimal number to NOT round up

[Guest]

i need to input decimal number. (1.5) it keeps rounding up to 2. i fixed
the decminal to 1 on the table, query, and form. i dont not want to number
to round up at all. what am i missing.

 

[Lynn Trapp]

What is the Field length property of the field? If it is set to Long
Integer, then change it to Double. Integers have no decimal values.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Al Camp]

What data type is the field. It should be Single or Double to handle
decimals. Not Byte or Integer or Long.

 

[Guest]

The field type in the table is probably set to Long type this type round the
number, set the field type to double