[AccessD] query expression help

Keith Williamson Kwilliamson at RTKL.com
Mon Nov 13 16:41:18 CST 2006


Thanks guys!!!!

Regards,

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


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan,
Lambert
Sent: Monday, November 13, 2006 3:33 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] query expression help

Using a calculated field expression in the query...

Calc Field Name: Iif(Instr([ProfitCenterName],"Architect")>0,"True
Value","False Value") 

This example creates a field called "Calc Field Name" which will wind up
with a string value of either "True Value" or "False Value". Of course
you
can equally easily arrange for IIF() to return numeric values or date
values, whatever you need.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith
Williamson
Sent: Monday, November 13, 2006 3: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
-- 
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