Creating query that will give me info on multiple people

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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?
 
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.
 
Back
Top