Number Rounding

S

Sam

How do I prevent rounding up or down. I'm using 2000 and regardless of what
type number I select, the result is rounding up or down. I want to be able
to enter a number i.e. 1.5 and have it appear and calculate as 1.5.
Thanks!
 
A

Allen Browne

Open your table in design view.
Select the problem Number field.
In the lower pane of table design, set the Field Size to:
Double

The Integer types handle whole numbers only.
 
L

Lynn Trapp

What is the "Field Size" for the column? If it is set to Long Integer (the
default for numbers) it will always round to the nearest whole number value.
Change it to Single, Double, or Currency.
 
Top