J
JK
I have a table that I imported from another database. The table has a couple
of thousend records in it and I'd like to keep the data intact. However, I'm
having trouble with a couple of the % columns. For example, the data is
appearing like this 70% when it should be appearing like this 0.7%. The
actual value in the field is 0.699999988 (that's the value shown when I click
on the field with the 70% value.) I need to know how to convert the table
field so that it shows 0.7%.
You should also know that I have the field size set to Double, I have the
field format set to Percent and I've tried playing around with the decimal
places but that only adds zeros after the 70% (i.e. 70.000%.)
Any help would be appreciated.
JK
of thousend records in it and I'd like to keep the data intact. However, I'm
having trouble with a couple of the % columns. For example, the data is
appearing like this 70% when it should be appearing like this 0.7%. The
actual value in the field is 0.699999988 (that's the value shown when I click
on the field with the 70% value.) I need to know how to convert the table
field so that it shows 0.7%.
You should also know that I have the field size set to Double, I have the
field format set to Percent and I've tried playing around with the decimal
places but that only adds zeros after the 70% (i.e. 70.000%.)
Any help would be appreciated.
JK