I’m am having a difficult time with a simple problem. I have queries in my parts databse that can search one field at a time with a wild card. I input the part number or portion of the part number and it returns all relevant records. I would like to modify this query to search more than one field within the same table (example; type in my search criteria and the query checks the part number fields, the third party part number fields, and the alternate part number fields. I’ve tried using various OR operators but I just can’t seem to get the syntax down. Any suggestions?
