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