Looking for Keywords in a Field

[wetsparks]

Hi all, back to access programing after several years away and the old grey matter isnt functioning like it used to



What am I trying to do? Simple version, create a data base with two fields, one Index the other Text Entry. In the Text field I create one record with the word "chair" in it, then more records with tile, cafe, sink. I then create some more records with chair tile, chair tile sink and chair tile sink cafe in them. So all in all I have 7 records. Now comes the query!

I can create a query to pull out say "chair" or "sink" on their own in it, but cant get the query to pull out the records containing say "chair" but also any other items in it. I have tried using comma and colon as delimiters but it dont work. Some help would be most welcome.

TIA.

[JoeM]

If you wanted to return all entries containing the word "chair", you could place this in the Criteria section of that field:

Like "*chair*"

[wetsparks]

Thanks for the quick reply.

To extend the question, how do I use the " [ ] " brackets to cause a popupbox to come up where I type in the search criteria?

[JoeM]

Try this in your Criteria:

Like "*" & [Enter search value] & "*"

[wetsparks]

That is just excellent, many thanks for your help here