Convert text number to decimal number

[Pete Provencher]

I have gotten some numbers from a mainframe that are decimal numbers but
they don't have the decimal mark. For example:

220
1450
16

I need to place the decimal point so that the numbers are as follows:

2.20
14.50
..16

I need to create an update query that will update the filed but I can't
figure out how to do this. Any help will be appreciated.


Pete Provencher

 

[Phobos]

UPDATE tblNumbers SET fld = [fld]/100;


P

 

[martin]

How do you know where the decimal point is supposed to be?

Martin

 

[John Viescas]

First, the data type of the field needs to be Currency, Decimal, Double, or
Single. You can then run an update query:

Update MyTable
Set MyField = MyField / 100

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411

 

[Pete Provencher]

Thanks. I just wish I had asked earlier. It would have saved me lots of
time.

Pete Provencher

UPDATE tblNumbers SET fld = [fld]/100;


P

I have gotten some numbers from a mainframe that are decimal numbers but
they don't have the decimal mark. For example:

220
1450
16

I need to place the decimal point so that the numbers are as follows:

2.20
14.50
.16

I need to create an update query that will update the filed but I can't
figure out how to do this. Any help will be appreciated.


Pete Provencher