How to extract Manager from job description field in pubs jobs tab

J

Jack

Hi,
I have a problem where I need to extract all the rows from job description
field of the job table in the pubs database. I need to use a parameter
statement in the query like [Enter job description]. When someone types
manager in this prompt all the rows corresponding to the job description that
has manager in the field should come up. I would appreciate any help how to
set up the parameter. I am using like Like "*[Enter description type]*".
However, this is not giving me the right answer. Thanks in advance.
 
J

John Spencer

You were close, but you need to concatenate the wild onto the user's input,
after the input is made. See below.

Criteria: Like "*" & [Enter description type] & "*"

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
J

Jack

Thanks a lot John. I appreciate it.
Regards

John Spencer said:
You were close, but you need to concatenate the wild onto the user's input,
after the input is made. See below.

Criteria: Like "*" & [Enter description type] & "*"

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Jack said:
Hi,
I have a problem where I need to extract all the rows from job description
field of the job table in the pubs database. I need to use a parameter
statement in the query like [Enter job description]. When someone types
manager in this prompt all the rows corresponding to the job description
that
has manager in the field should come up. I would appreciate any help how
to
set up the parameter. I am using like Like "*[Enter description type]*".
However, this is not giving me the right answer. Thanks in advance.
Click to expand...
Click to expand...
 
Top