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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use the following in your query criteria...

Like "*" & "marketing" & "*"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter lookup based on field value in current record 3
Importing Data from Access 1
VBA: How can I use a string variable as autofilter criteria? 4
if-then statements in a query 6
Format Properties for Number That Contain Powers 5
Name a text field containing formulas 3
Importing Text Files Into Access 1
Outlook Contacts to Access 3

Back
Top