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

As criteria for the [JobDescription] column write:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top