extracting a substring

obs

Registered User.
Local time
Yesterday, 23:48
Joined
Mar 1, 2007
Messages
25
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 !!!
 
use the below as your criteria

Like "*soccer*"
 
You should have created another table for activities and created an one-to-many relationship to Kids and Activities.
 
Thanks Keith, you've been great help!
 

Users who are viewing this thread

Back
Top Bottom