Number Rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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.
 
Back
Top