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.
 
You must log in or register to reply here.

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

Creating a query with multiple items from a single field 1
Counting multiple memberships 1
Creating a query for multiple tables in one database 4
Automating a report that is based on a query 4
Main Table References Another Table Multiple Times 4
joining multiple records 2
Multiple Queries to Multiple Reports 1
Create a Query that Prompts for Date and Time 4

Back
Top