[AccessD] query expression help

Use InStr().  It returns the starting position of one thread in another.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith
Williamson
Sent: Monday, November 13, 2006 12:21 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] query expression help

Hey guys....

I'm blanking.  If I want to create an expression, in a query, that
checks another field for specific text....ie:

Check field [ProfitCenterName] with value of:

Associates Retail Balto.Architecture

....to see if "Architect" is within the text...and if so, return a value
of "21".......

How do I do this?  I've got a query, I want to check the text within
another field....to see if certain text is buried within the value of
that field...and if so, populate the expression I am building in the
query.

Thanks,

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com