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?
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?