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.