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

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

Similar Threads

Multiple word search Parameter Query 4
Need help building query into form 3
sql query reqest 1
Query to duplicate a record with one field updated 0
Problem with a parameter query 7
Have both records from two queries/tables under one Query without related fields. 0
Creating OR, AND query in access and getting parametrs frm access 2
criteria in query from form 4

Back
Top