wHY DO ALL MY NUMBER FIELDS KEEP ROUNDING IN ACCESS

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


"Mike McCarron" Mike wrote in message
...
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

On Thu, 7 Apr 2005 09:25:06 -0700, "Mike McCarron" Mike
wrote:

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]