Creating a query with multiple items from a single field

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top