Eliminate items in a query by selecting text in the description (1 Viewer)

[!Rdooley]

Hello all,

I have a table that contains records of merchandise.

Item #, Description, Price.

The description field is text and I want to remove any records that have the words "stay" or "stays" in the full description.

Can I use the [criteria] in a query to <>"stays"? I tried this and its looking for records that only have the word stays as the description.

Any Ideas??

Thanks

 

[dcx693]

Use:
Not Like "*stays*"
as your critieria

 

[!Rdooley]

Thanks Alot