Using a parameter query to find words in a text field

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

Guest

I have a text field which contains one or more words separated by commas.
I'm trying to construct a parameter query which prompts for one of the words
and returns records which have that word in the text field. Any ideas?
Thanks.
 
Hi,
use wildcard characters and the like operator.
In the parameter query text field criteria area you could try something like:

Like "*" & [Your Value:] & "*"

It should now filter correct as you wish.
HTH
Good luck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count text values in a Access Field 0
Problem with a parameter query 7
Extracting a word from a long text field 5
parameter for text 9
Parameter queries 2
Search for words in a record 2
Split data in field on character return 0
Instr parsing with a comma delimited string 3

Back
Top