Yes, I'll start from the beginning.  I have a table with about 8 fields.  In order for my team to easily enter data, I created a corresponding form.  As we all know, searching in Access is not easy, so through your YouTube video and other sites, I created a new Search form, added my fields from the table, created the search query and added the appropriate macro to run the search.  I set up the query like I specified above to search those fields using "and", so field 1 contains "report" and field 2 contains "data" and my results return where that criteria is met with both fields.  The team wanted an "or" option, so return all records where field 1 contains "report" OR field 2 contains "data".  The problem is when I use the  (Like "*" & [Form Field] & "*" )  with or statements, it simply returns all rows all the time.  Ultimately, I just want it to return the correct results if I say Field 1 contain x or Field 2 contains x or Field 3 contains x, etc.... It seems that by using the LIKE, it says "return anything" or "return anything", so it is returning me everything.

---

Reply from Richard Rost:

Yes, now you're starting to get complicated. I am going to recommend for a form like this using the DYNAMIC SQL method that I show in several of my courses - where you actually construct an SQL statement to perform the search. However, you can TRY wrapping your criteria inside of an IIF function using IsNull to check to see if the user put a value in that form field. It's pretty difficult, and takes a few steps, but I will be covering this in my Search Seminar which should be out this weekend or early next week. Hang in there. :)