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

Brad

If it is always like your examples, i.e. letters-space-numbers, then this 
will do it:
Left([NameOfField],InStr([NameOfField]," ")-1)

Regards
Steve

-----Original Message----- 
From: Charlotte Foust
Sent: Thursday, May 17, 2012 10:20 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to Eliminate a Numeric String from a Field in an 
Access Query

Will the values follow a specific pattern, i.e. characters then numbers?
If so  you could write a quick function to start at the end of the string
and test each character until it hits an alpha, then return the left part
of the string up to that point.

Charlotte Foust

On Wed, May 16, 2012 at 12:44 PM, Brad Marks 
<BradM at blackforestltd.com>wrote:

> 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
>
>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com