Search Text for words

[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?

 

[Jeff Boyce]

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

 

[Marshall Barton]

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?

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

 

[Gary F Shelton]

Works like a charm...
--
GS

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