Text Field Contains Specific String

[sharrell]

I need to filter or query my records based on a text field containing a certain string.

Basically, I have an item description. I need to return only those records that contain "screw" or "nut" or whatever else I want to enter.

Thanks!

 

[pm709]

Just put the desired word in the criteria box and the query will return only records containing that word, you can specify: "your_whole_word", or "*Like_this_word" etc. You can find many ways to specify criteria in a query in access help.