Why is Access rounding off numbers

A

Anthroslug

I work in a federal office, and for some reason Access automatically rounds
off all numbers entered into a table on every computer that we have here.
Even when I edit the table specifically so that the value of the numbers
entered will be displayed out to a few decimal places, Access automatically
rounds them off. Is there any way to fix this without re-installing Access
(which would be both time-consuming and unlikely to help as all of the
computers here have the same issue).
 
M

M Skabialka

What is the format of the number in your table?

Bytes and Integers do not allow decimal places; single, double, and decimal
do.

We need more info before any advice can be given, because you can't just
change number types while there is valid data in those fields.

Mich
 
A

Albert D. Kallal

Likely, you have the wrong type of field specified.
Even when I edit the table specifically so that the value of the numbers
entered will be displayed out to a few decimal places
Click to expand...

Are you saying that you went to the table design, and changed the data type?

Bring up the table in design mode, and select the particular field. Now,
place your cursor in the "Field Size" box, and then hit the help key.

You should now see an explain of the data types. You MUST select the correct
data type BEFORE you set things like formatting, and the number of decimal
places.

If the values you are entering are dollar amounts..then you should use
currency data type (this only allows 4 decimal places).

Also, since you are new to this stuff, then try/test only on a back of the
data...not the original....
 
L

Larry Linson

I work in a federal office, and for
some reason Access automatically
rounds off all numbers entered into
a table on every computer that we
have here.
Click to expand...

In the early days of computing, I heard a story about a programmer at a bank
who accumulated the fractional cents dropped in their calculations to his
own account (before he was caught and prosecuted). You don't suppose someone
has programmed your Access databases to do the same, do you?
 
L

lvjinhua

test
Larry Linson said:
In the early days of computing, I heard a story about a programmer at a
bank
who accumulated the fractional cents dropped in their calculations to his
own account (before he was caught and prosecuted). You don't suppose
someone
has programmed your Access databases to do the same, do you?
Click to expand...
 
Top