How to Find Data in Part of Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

doyle60@aol.com - 07 Mar 2007 22:25 GMT

I have a query with a field called Fabric. I want to create a column
in the query that returns Yes if any part of the Fabric field has the
letters "cot" in it.

So I naturally thought to put asterics around the word ("*Cot*") and
writing this:

Cot: IIf(Fabric = "*Cot*","Yes")

But it doesn't work and returns nothing for all.

How do I do this correctly?

Thanks,

Matt

Reply to this Message

bob - 07 Mar 2007 22:31 GMT

cot:iif([fabric] is like "*" & "cot" & "*","Yes", "")

Bob

>I have a query with a field called Fabric. I want to create a column
> in the query that returns Yes if any part of the Fabric field has the
[quoted text clipped - 12 lines]
>
> Matt

Reply to this Message

doyle60@aol.com - 08 Mar 2007 14:11 GMT

Thanks Bob. But it didn't work. After five minutes of playing around
with it, I was able to figure out that "Like" was needed and not "Is
Like". So this works:

Cot: IIf([Fabric] Like "*" & "cot" & "*","Yes","")

Thanks,

Matt

Reply to this Message

fredg - 07 Mar 2007 23:32 GMT

> I have a query with a field called Fabric. I want to create a column
> in the query that returns Yes if any part of the Fabric field has the
[quoted text clipped - 12 lines]
>
> Matt

Cot:IIf(Instr([FieldName],"Cot")>0,"Yes","No")

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message