extracting a substring

[obs]

Hi Everybody,
I have an access database and in a certain table I have a string field which has two values. I want to make a query that will show all the fields which contain a substring.

I'd better give an example:

Table: Kid

Fields:
Name: Ben
Activities: Soccer, Tennis

Name: Dan
Activities: Soccer

Name: John
Activities: Football, Origami


.
.
.

I want to show in a query all the Names which have a "Soccer" substring in their Activities string field

Need your help ASAP !!!

 

[KeithG]

use the below as your criteria

Like "*soccer*"

 

[KeithG]

You should have created another table for activities and created an one-to-many relationship to Kids and Activities.

 

[obs]

Thanks Keith, you've been great help!