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

Re: " I very much doubt that you will have any hassles with functions the
likes of Left, InStr, Split."

Agreed, although you may experience performance problems with "UDFs".
I've caught Access calling these TWICE for each row...on occasion.


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Steve Schapel
> Sent: Sunday, May 20, 2012 5:14 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] How to Eliminate a Numeric String from a Field
> inanAccess Query ---- THANKS!
>
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com