Access criteria expressions

I don't have a ton of Access use experience but:

Job Titles is a column in the database.
In Queries, the user can type in a word and it will find the job title and
corresponding ID number but it will only find it from the beginning of the
job title.
I've tried all morning to use different expressions to have it find any part
of the job title, for example, if the type in Nurse it will find 'Nurse' and
also 'emergency nurse'.
Here's where I am now:

Like [Enter Job Title] & "*"

Please help!

Like "*" & [Enter a Job Title] 7 "*"

HTH;

Amy

"Rynorem" wrote in message
...
I don't have a ton of Access use experience but:

Job Titles is a column in the database.
In Queries, the user can type in a word and it will find the job title and
corresponding ID number but it will only find it from the beginning of the
job title.
I've tried all morning to use different expressions to have it find any
part
of the job title, for example, if the type in Nurse it will find 'Nurse'
and
also 'emergency nurse'.
Here's where I am now:

Like [Enter Job Title] & "*"

Please help!

Oops

Like "*" & [Enter a Job Title] & "*"

Sorry bout that

"Rynorem" wrote in message
...
I don't have a ton of Access use experience but:

Job Titles is a column in the database.
In Queries, the user can type in a word and it will find the job title and
corresponding ID number but it will only find it from the beginning of the
job title.
I've tried all morning to use different expressions to have it find any
part
of the job title, for example, if the type in Nurse it will find 'Nurse'
and
also 'emergency nurse'.
Here's where I am now:

Like [Enter Job Title] & "*"

Please help!

Worked. Thanks Amy.

"Amy Blankenship" wrote:

Oops

Like "*" & [Enter a Job Title] & "*"

Sorry bout that

"Rynorem" wrote in message
...
I don't have a ton of Access use experience but:

Job Titles is a column in the database.
In Queries, the user can type in a word and it will find the job title and
corresponding ID number but it will only find it from the beginning of the
job title.
I've tried all morning to use different expressions to have it find any
part
of the job title, for example, if the type in Nurse it will find 'Nurse'
and
also 'emergency nurse'.
Here's where I am now:

Like [Enter Job Title] & "*"

Please help!

You're welcome.

-Amy

"Rynorem" wrote in message
...
Worked. Thanks Amy.

"Amy Blankenship" wrote:

Oops

Like "*" & [Enter a Job Title] & "*"

Sorry bout that

"Rynorem" wrote in message
...
I don't have a ton of Access use experience but:

Job Titles is a column in the database.
In Queries, the user can type in a word and it will find the job title
and
corresponding ID number but it will only find it from the beginning of
the
job title.
I've tried all morning to use different expressions to have it find any
part
of the job title, for example, if the type in Nurse it will find
'Nurse'
and
also 'emergency nurse'.
Here's where I am now:

Like [Enter Job Title] & "*"

Please help!