I have an Access 2010 DB that has multiple fields with various information in them. An example. Item 1 Item 2 Item 3 ~~~~ item 25. All the information in these fields have numerous data in them from a chrome plating shop. They could include, but not limited to, bumpers, radiators, wheels, posts, hood, valve covers, bezels, handles, brackets, grill, etc. The list is very extensive. Each record has a name, company, type of auto, or other associated with the Item 1 through Item 25 field. What I need to do is design a query so a parameter can be used as an input to search the 25 fields for any one of the items in the field. Example. What item do you need? What is name of company, customer, or type of auto associated with the part chromed. If you wanted a bumper for a 1960 chevy corvette, everything is easy to find except which field 1~25 has the word or word in a phrase = to bumper. I have tried many ways to design the query by design view or SQL and just can not get it to work properly. I have very successfully found what I needed to find the item if it is in Item 1, however is it is in item 2~item 25 I can not find it. I have tried using the same criteria on the other fields ( item 2 ~ 25) but when I do this the AND logic seems to eliminate the item I need to find. The items were not entered in any specific order when the database (Access 2000) was first set up for it. The employee might have entered a bumper as the first item one day and maybe entered a grill as the first item the next day. As a result Item 1 of one record does not line up with Item 1 of another record, however Item 5 might. The database has about 5,000 records and I do not even want to think of a redesign as I do this on a voluntary basis for my friend. Any help, examples, or other info much appreciated.