[AccessD] How to Eliminate a Numeric String from a Field in anAccess Query

Jim Lawrence accessd at shaw.ca
Wed May 16 15:07:29 CDT 2012


Hi Brad:

Trim(left("AAA 1234",inst("AAA 1234"," ")))

There seems to be a space between the letters and numbers so the easiest way
to strip the letters out would be the above.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Wednesday, May 16, 2012 12:45 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to Eliminate a Numeric String from a Field in
anAccess Query

We are pulling data from a purchased package via an Access 2007 Query.

One of the fields has a combination of Alphabetic characters and
numbers, such as these examples.

ABC 1234
BB  1234556
CCC 55

Is there a way to eliminate the numeric part of the strings in these
records within an Access Query?

"ABC 1234" would become ABC
"BB  1234556" would become BB
"CCCDD 55" would become CCCDD

Thanks,
Brad

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list