wHY DO ALL MY NUMBER FIELDS KEEP ROUNDING IN ACCESS

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

Guest

I just started using access created table with number fields. Set the number
fields to long integer, fixed 2 decimal places. Everytime I put a number in
it round up or down and I see XXX.00 in the table. How do I turn this
automatic rounding off
 
What type/size of field is it?

If it is an integer, then you can't have decimals.

Go to the table and change the field to a "Field Size" that supports
decimals.

Rick B
 
On Thu, 7 Apr 2005 09:25:06 -0700, "Mike McCarron" <Mike
I just started using access created table with number fields. Set the number
fields to long integer, fixed 2 decimal places. Everytime I put a number in
it round up or down and I see XXX.00 in the table. How do I turn this
automatic rounding off
Click to expand...

A Long Integer *IS AN INTEGER* - and, if you check the definition of
the term integer, you'll see that it's a whole number. Long Integers
*don't have decimal places* and cannot be made to do so. It's annoying
that Access includes the decimal places option, which is appropriate
for Single or Double numbers but not for the default long integer!

I'd suggest not using a Number field type; instead, use a Currency
field type. Despite the name, this is just a number - a huge scaled
integer with four (exactly four, nor more, no fewer) decimal places.


John W. Vinson[MVP]
 
Back
Top