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