Microsoft Access query on limiting data in a field

[Guest]

For instance I am using MS Access 2003 and have a table wtih a field with the
following text 012345A. How do I do a query so that I can create a new field
containing just the text 012345?

 

[MGFoster]

For instance I am using MS Access 2003 and have a table wtih a field with the
following text 012345A. How do I do a query so that I can create a new field
containing just the text 012345?

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

I'm not sure you want to create a new column in the table (do you?) or
just in the query. If all the values in that column (field) have 6
numerals and a trailing alpha character, you can do this in a query:

SELECT Left(column_name,6) As numeric_data, < other columns >
FROM table_name
WHERE ...

The Left(column_name,6) will get the leading 6 numerals of the data.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBRJC0p4echKqOuFEgEQLYdQCggdCSNfM+EBg4fo5SaYK53rqCZaEAoM4x
miQN52ATgcBXlQcWCnMDCNXQ
=whLA
-----END PGP SIGNATURE-----

 

[Guest]

Thank you for your quick and accurate response. It works.