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

Brad Marks BradM at blackforestltd.com
Thu May 17 14:17:08 CDT 2012


All,

Thanks for the advice and examples. I appreciate the help.

I was vaguely aware of the use of Functions in Queries but I have not
done much in this area.

About a year ago, we had a function in a query that was pulling data
from SQL-Server and the performance was not acceptable.  We had to use
an alternative approach.

In this most recent situation, performance will not be a problem because
the number of rows is quite small.

Thanks again for the assistance.

Brad
  



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Wednesday, May 16, 2012 2: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

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




More information about the AccessD mailing list