Lookup option in a Query

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

Jason

I have a table of jobs my compnay has done for the past
few years. In the "Job Name" field we put a small
description of the job (i.e. Direct Mail for John Smith)
I want to set up a query so that a user can type a
parameter in the box like "Enter Job Name" and they can
type in "mail" or anything else similar and it will pull
up all jobs that have the word "mail" in them. Right now
all I can figure out is [Enter Job Name] in the criteria
but when the prompt comes and I type in mail, nothing
comes up because it seems to be looking for that exact
spelling of the first word of the job name.

Any help is appreciated.
 
Try putting " Like "*" & [Enter Job Name] & "*" " (omit the outer
quotes) in Criteria.

LeAnne
 
Cool that seems to work.

-----Original Message-----
Try putting " Like "*" & [Enter Job Name] & "*" " (omit the outer
quotes) in Criteria.

LeAnne
I have a table of jobs my compnay has done for the past
few years. In the "Job Name" field we put a small
description of the job (i.e. Direct Mail for John Smith)
I want to set up a query so that a user can type a
parameter in the box like "Enter Job Name" and they can
type in "mail" or anything else similar and it will pull
up all jobs that have the word "mail" in them. Right now
all I can figure out is [Enter Job Name] in the criteria
but when the prompt comes and I type in mail, nothing
comes up because it seems to be looking for that exact
spelling of the first word of the job name.

Any help is appreciated.
Click to expand...
.
Click to expand...
 
Back
Top