Creating a query with multiple items from a single field

G

Guest

is there a simple way to create a query to retrieve multiple field
components? by this i mean i need to pull data on specific people within our
database. is there a way that i could enter ALL of the names of these people
to return the data i need rather than querying them one at a time?
 
M

[MVP] S.Clark

Quick and Dirty:
Select * from tablename where PersonName IN ("Steve Clark", "Maria Shriver",
"Tom Hanks")

Long and Clean:
To the table of person names, add a Yes/No column called Pick
Check all the people that you would like to have queried.
Use the Criteria where Pick = True.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html
 

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

Query milliseconds in a date field that is in a SQL Server table l 2
formating a field within a query 11
Denormalize data into one single field (by query) 2
Query to choose multiple criteria from a field 6
Multiple criteria from a single field in a Select Query 1
Multiple "Not Like" not working 5
Can't query datetime field formatted as m/d/yyyy 1
Running a Query to Obtain One of Multiple Values in a Field 4

Top