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] & "*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weekly Report 2
Creating a Chart on form from selected data in query. 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
QBF & Query Malfunction 0
Query to select individual records 4
Selecting unique record from duplicate 2
Unable to display values in 2nd list box from 1st list box selection 2
Dealing with the error: unable to filter on excel hc home school 0

Top