Creating query that will give me info on multiple people

W

woods1119

is there a way i can create a query that will return the info i want on
multiple people? for instance, i need to DOB from tblPtData on roughly 40+
people. the database is too large to make a simple query and look
through...it's just time consuming. thought maybe there'd be an easier way???
 
R

Rick B

Is there something in your "people" table that you can use. For example, do
you want to pull everyone in a certain department, or everyone employed more
than XX Years?

In other words, what is your criteria for the 40 people? Can you use that
in your query?
 
W

woods1119

No, it's data on patients. There are other criteria I need but they are
person specific, not all the 40 have X in common. Unfortunately I need the
DOB on "John Smith" and other specific people rather than everyone in the
database. I thought there might have been an easier way to gather the data
than looking up each patient.
 
Top