Query to select from list

N

nbslarson

I have a table which contains one field "connector" which could contain one
name or more than one name.
Is there a way to build a query that will travel through the table and
select the records that contain that person's name (John Smith)?
Any help you can offer is greatly appreciated.
 
K

KARL DEWEY

Are you saying you have multiple names in a single field? Or is that field
for the name may have multiple records?

The first is the wrong way to store data but if that is what you have then
you can use this as criteria --
Like "*" & [Enter search name] & "*"
 
Top