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

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 



More information about the AccessD mailing list