Search Text for words

  • Thread starter Thread starter Gary F Shelton
  • Start date Start date
G

Gary F Shelton

I have a list of descriptions that have the word TRAX or CROSS in them at
random. I want to only return the records that have this in the text. How do
I write a query to return these records?
 
Gary

Open a new query. Add the table. Add the fields of interest

In the Selection Criterion under the [description] field, use something like
(untested):

Like * & "TRAX" & * or Like * & "CROSS" & *

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Gary said:
I have a list of descriptions that have the word TRAX or CROSS in them at
random. I want to only return the records that have this in the text. How do
I write a query to return these records?
Click to expand...


Set the field's criteria to something like:
Like "*TRAX*" OR Like "*CROSS*"
 
Back
Top