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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
..
 
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...
 
Back
Top