Find string in multiple rows of a query datasheet

[dvgef2]

Good Morning,

Is it possible to search through multiple columns of a Table and return only those rows of data that have an exact match of a string without having to put the string in the Criteria row for each applicable column in the query?

I don't know how to do SQL but the query I need has several 'like' columns in it such as Item description or Unit of Issue, quantity etc. They are distinguished in the Table as Item Description1, Item Description2 etc. up to 10. It is kind of like a receipt you get in a grocery store where you have several lines of all the things you bought with the description, quantity, cost, unit of issue etc. listed on the receipt.

I would like to search through all the item descriptions to find certain things. One example would be to search through 'ItemDescript1' through 'ItemDescript10' and find the string "Lettuce" without having to go to each applicable column in the query and type Like "Lettuce" in the Criteria row. It would be nice for the query to ask for the string first and then search all the columns in the table for that string.

I don't always express myself very well and I apologize in advance if there is nothing but confusion in this question. Thanks for your time!

[orange]

Take a look at https://www.accessforums.net/showthread.php?t=43055 and see if it is applicable to your situation.

[dvgef2]

Thank you for your quick response Orange! I think that this will work....if I can figure out how to do it right in my database.

I will work with it, thanks again for your help!

Dave