Query to search for a word

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have a field in my table called "Job Description" it
consists of several words usually, I want a query to have
a pop up box that says "Enter Word" so if I enter the
word "houston" it pulls all records that have the
word "Houston" in the field.

What kind of criteria can I use for this, I am stumped!!

Jason
 
I have a field in my table called "Job Description" it
consists of several words usually, I want a query to have
a pop up box that says "Enter Word" so if I enter the
word "houston" it pulls all records that have the
word "Houston" in the field.

What kind of criteria can I use for this, I am stumped!!

Jason
Click to expand...

As criteria for the [JobDescription] column write:

Like "*" & [Enter Word] & "*"
 
Back
Top