Steve Schapel
steve at datamanagementsolutions.biz
Sun May 20 16:14:26 CDT 2012
Brad I am aware of performance problems sometimes resulting from the use of domain aggregate functions such as DLookup in queries. And also with some recordset-based user defined functions. I very much doubt that you will have any hassles with functions the likes of Left, InStr, Split. Regards Steve -----Original Message----- From: Brad Marks Sent: Friday, May 18, 2012 7:17 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How to Eliminate a Numeric String from a Field inanAccess Query ---- THANKS! 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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com