Query to select from list

  • Thread starter Thread starter nbslarson
  • Start date Start date
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.
 
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] & "*"
 
Back
Top