changing text data to decimal data

[LAF]

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

 

[Jeff Boyce]

"?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>

 

[LAF]

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

 

[Jeff Boyce]

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