Chagne Numberic to Text - Retain ALL Characters

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

Guest

I have data in a numeric field in an Access 2003 database that looks like:

035327148

I am looking for a way that I can convert this to a "text" field...and have
the data retain all 9 digits (including the leading zero)????

Thanks
Warren Phillips
 
That was it.....Thank you very much

John Spencer said:
Try the following in a new column

Format([YourField],"000000000")



Warren Phillips said:
I have data in a numeric field in an Access 2003 database that looks like:

035327148

I am looking for a way that I can convert this to a "text" field...and
have
the data retain all 9 digits (including the leading zero)????

Thanks
Warren Phillips
Click to expand...
Click to expand...
 
Warren said:
I have data in a numeric field in an Access 2003 database that looks like:

035327148

I am looking for a way that I can convert this to a "text" field...and have
the data retain all 9 digits (including the leading zero)????
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you change a column's data type from a Numeric data type to a Text
you will have to use something like this to keep the leading zeros:

Format(NumericValue,String(9,"0"))

This:

Format(25,String(9,"0"))

would yield this:

000000025

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRFkryoechKqOuFEgEQJaUgCcCYZQ98hBJekqI7F/bwiLJkxf9TYAoIQa
l4eNeAnXmpXl4LQjr6YUXZWf
=R6Uq
-----END PGP SIGNATURE-----
 
Thank you for the help

MGFoster said:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you change a column's data type from a Numeric data type to a Text
you will have to use something like this to keep the leading zeros:

Format(NumericValue,String(9,"0"))

This:

Format(25,String(9,"0"))

would yield this:

000000025

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRFkryoechKqOuFEgEQJaUgCcCYZQ98hBJekqI7F/bwiLJkxf9TYAoIQa
l4eNeAnXmpXl4LQjr6YUXZWf
=R6Uq
-----END PGP SIGNATURE-----
Click to expand...
 
Back
Top