converting text to number

[Barb]

I have been supplied with data extracted from a third party database. I have
two CSV files for two different tables. I have also been given an Access
2003 database that the two CSV tables have been imported into and linked via
a query. The problem is that one of the fields should be a number with one
decimal place. It currently exists a text field in Access. When I change
the design of the field in Access from text to number (1 decimal place) I get
a number that is rounded to a whole number and lose the decimal place. What
am I doing wrong?

 

[Steve Schapel]

Barb,

When you change it to Number data type, you will have to use a setting
for the Field Size property that supports decimals, i.e. Single or
Double, not Integer or Long Integer.

Alterrnatively, you can change the Data Type to Currency... that's what
I would probably do.

 

[malvernbill]

Steve,

You're a lifesaver! I had a similar problem in that when I imported an excel
file with the numbers formatted as text, the numbers right of the decimal
point were truncated. Switching the field size to 'double' did the trick!

Thanks again,

Bill