changing text data to decimal data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to change a text field that has values ranging from 0,1,2,3, and T.
It is easy to use find and replace to change the T to 0.25. However, access
strips the decimals off when I modify the text field to numeric, integer,
decimal 2. What is the best way to convert a text field into a numeric field
while preserving the decimals.

Thanks, LAF
 
"?Integer?" "?decimal?" Integers don't have decimal places.

If you'll need 4 or fewer decimal places, consider using the Currency data
type.

Regards

Jeff Boyce
<Office/Access MVP>
 
Thanks, Jeff.

Access table in design view permits integer to have an entry for decimal
points. One further question. Is there a straightforward way to do this
without using currency? After I modify the data in the access table, I am
going to import the table into S-plus for statistical analysis.

LAF
 
Currency data type doesn't mean you have currency (I don't know WHO named it
that?!). Currency data type is a 4-decimal-place number. If you need more
precision than that, use Single.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
 
Back
Top