How to Restore Decimal Numbers

[Larry Bohen]

I have an Access db with about 9100 records. One of the fields was a
"Currency" field with numbers like 11.16, 13.51... Although the $ sign
doesn't show in my db, it does show when I do a query and upload records to
an ecommerce program.

A recent change to an ecommerce program didn't like the $ sign in the
uploads so I was advised to change the field type from Currency to Number or
Text. I changed it to Number (with 2 decimal places) and all 9100 numbers
(11.16, 13.51....) were rounded to the nearest whole dollar.

How do I restore the numbers (2) to the right of the decimal place? I am
hoping there is a global way of doing this rather than individually.

 

[Joseph Meehan]

I have an Access db with about 9100 records. One of the fields was a
"Currency" field with numbers like 11.16, 13.51... Although the $ sign
doesn't show in my db, it does show when I do a query and upload records
to
an ecommerce program.

A recent change to an ecommerce program didn't like the $ sign in the
uploads so I was advised to change the field type from Currency to Number
or
Text. I changed it to Number (with 2 decimal places) and all 9100 numbers
(11.16, 13.51....) were rounded to the nearest whole dollar.

How do I restore the numbers (2) to the right of the decimal place? I am
hoping there is a global way of doing this rather than individually.

What type of number did you use? Hopefully it was not Integer. Access
stores number in several formats. In Integer it does not store the decimal
part. Integer is whole numbers only. After the number is stored each time
it is displayed it may be formatted several ways including with two or no
decimals.

If you changed to a integer type number the decimals parts are gone.
Hopefully you have a backup. Otherwise .... 9100 corrections Ouch!
Painful way of learning to back up early and often.

 

[Van T. Dinh]

I hope you have a back-up copy of the data???

When you changed the Field type to Number, you need to specify the size of
the number to Decimal or Double or Single. If you specified Long or Integer
of Byte which can only store *whole* numbers, you existing values would have
been rounded so that they fit into the new file Type / Size.