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