If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
#5
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MS Access criteria HELP!! | dawnovan71 | Running & Setting Up Queries | 3 | January 27th, 2005 05:29 PM |
Access Error Message when opening database | eah | General Discussion | 3 | January 26th, 2005 10:04 AM |
Merging MS Word document with MS Access 2002 criteria query | Doug Robbins | Mailmerge | 2 | November 4th, 2004 05:57 PM |
Need help with Access decision | aualias | General Discussion | 23 | June 21st, 2004 02:04 AM |
writing criteria in access and using pivot in excel | Frank Kabel | Worksheet Functions | 2 | March 23rd, 2004 04:35 PM |