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

Guest · May 17, 2006

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.

Guest · May 17, 2006

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

Ron2006 · May 17, 2006

Look up help on the function

Instr

Rick B · May 17, 2006

Use the following in your query criteria...

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

Guest · May 17, 2006

Thx, very helpful...

Rick B said:
Use the following in your query criteria...

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

Guest · May 17, 2006

Thx -- very helpful.

KARL DEWEY said:
Use this as criteria --
Like "*"&"marketing"&"*"

Filter lookup based on field value in current record	3	Mar 1, 2012
Importing Data from Access	1	Dec 9, 2007
VBA: How can I use a string variable as autofilter criteria?	4	Apr 25, 2019
Multiple Selection Criterial Query some with NULL fields	5	Mar 10, 2009
Importing Text Files Into Access	1	May 2, 2018
Outlook Contacts to Access	3	Jun 30, 2008
Averaging fields, ignoring blanks	3	Jan 30, 2009
combining two or more table fields into a single table field	1	Feb 20, 2009

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

Guest

Guest

Ron2006

Rick B

Guest

Guest

Ask a Question

Similar Threads