Create a Search Word Criteria in a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has about 300 fields. I have created a main screen that
gives you options to create a new record or search for a key word. I have
the query set for the word search, but can't get the criteria part right. I
want the criteria to search the entire table for a word or set of words.
Thanks
 
What is the structure of your table? Why would you need to search the
entire table for a word rather than just a particular field where the word
is expected?

I fear that you have a poorly designed database.
 
Back
Top