Eliminate items in a query by selecting text in the description

!Rdooley

New member
Local time
Yesterday, 19:13
Joined
Oct 17, 2003
Messages
7
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
:confused:
 
Use:
Not Like "*stays*"
as your critieria
 
Thanks Alot :D
 

Users who are viewing this thread

Back
Top Bottom