Parmeters involving two key words

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

Guest

I have table with the field Description set up as a memo field. I have a
query which includes a parameter to search this field using the key word I
enter so that it will locate the word anywhere in the field and return those
records and this works well. This is the Criteria I used.

Like "*" & [Type Key Word for Description] & "*"

However, to streamline the returns I would like to be able to enter two
words that may not be adjacent words and limit the returns to only those
records that include those two words any where in the description field.

Can anyone help on how to set this up?
 
This worked great, thank you!!!!
--
Ginny


Ron Weiner said:
How about

Like "*" & [1stWord] & "* AND Like *" & [2ndWord] & "*"

--
Ron W
www.WorksRite.com
Ginny said:
I have table with the field Description set up as a memo field. I have a
query which includes a parameter to search this field using the key word I
enter so that it will locate the word anywhere in the field and return those
records and this works well. This is the Criteria I used.

Like "*" & [Type Key Word for Description] & "*"

However, to streamline the returns I would like to be able to enter two
words that may not be adjacent words and limit the returns to only those
records that include those two words any where in the description field.

Can anyone help on how to set this up?
Click to expand...
Click to expand...
 
Back
Top