Number Rounding

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sam" wrote in message
news
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!

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.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Sam" wrote in message
news
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!