Query to search for a word

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
 
F

fredg

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] & "*"
 
Top