How can I check if a field "contains" a string?

#1 (**permalink**) 28-Jul-2006, 08:07 AM

I've imported my Outlook contacts into Access. I want to isolate all records
where the category field contains the word "marketing". It is sometimes
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9815-how-can-i-check-if-field.html
first in the field, and sometimes last.

*

#2 (**permalink**) 28-Jul-2006, 08:07 AM

Use this as criteria --
Like "*"&"marketing"&"*"

"CVoelker" wrote:

> I've imported my Outlook contacts into Access. I want to isolate all records
> where the category field contains the word "marketing". It is sometimes
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9815
> first in the field, and sometimes last.

#3 (**permalink**) 28-Jul-2006, 08:07 AM

Look up help on the function

Instr
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9815

#4 (**permalink**) 28-Jul-2006, 08:07 AM

Use the following in your query criteria...

Like "*" & "marketing" & "*"

--
Rick B

"CVoelker" wrote in message
news:544A31FC-EB08-4054-ABFC-AD4CC47F203D@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9815
> I've imported my Outlook contacts into Access. I want to isolate all
> records
> where the category field contains the word "marketing". It is sometimes
> first in the field, and sometimes last.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9815

#5 (**permalink**) 28-Jul-2006, 08:07 AM

Thx, very helpful...

"Rick B" wrote:

> Use the following in your query criteria...
>
> Like "*" & "marketing" & "*"
>
>
>
> --
> Rick B
>
>
>
> "CVoelker" wrote in message
> news:544A31FC-EB08-4054-ABFC-AD4CC47F203D@microsoft.com...
> > I've imported my Outlook contacts into Access. I want to isolate all
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9815
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9815
> > records
> > where the category field contains the word "marketing". It is sometimes
> > first in the field, and sometimes last.
>
>
>

#6 (**permalink**) 28-Jul-2006, 08:07 AM

Thx -- very helpful.

"KARL DEWEY" wrote:

> Use this as criteria --
> Like "*"&"marketing"&"*"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9815
>
> "CVoelker" wrote:
>
> > I've imported my Outlook contacts into Access. I want to isolate all records
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9815
> > where the category field contains the word "marketing". It is sometimes
> > first in the field, and sometimes last.