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
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]