Access criteria expressions

R

Rynorem

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!
 
R

Rynorem

Worked. Thanks Amy.

Amy Blankenship said:
Oops

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

Sorry bout that

Rynorem said:
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!
Click to expand...
Click to expand...
 
A

Amy Blankenship

You're welcome.

-Amy

Rynorem said:
Worked. Thanks Amy.

Amy Blankenship said:
Oops

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

Sorry bout that

Rynorem said:
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!
Click to expand...
Click to expand...
Click to expand...
 
Top