finding text with query

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

Guest

I have several records that contain the word "box" in the text. How do I
pull all the records that contain that word?
 
Create a query that contains your text field and any other fields you need
to return. Put the following expression in the criteria of the text field:
Like "*" & "Box" & "*"
 
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

Split column contents (de-concantenate) 7
Count text values in a Access Field 0
Need to compare 2 tables and only pull certain records from one ta 3
iif function syntax problem 5
Have both records from two queries/tables under one Query without related fields. 0
Finding Similar Text ? 1
Filtering a table by using criteria in another table 1
Delete Records Where The Like* Can Be used?? 3

Back
Top