Help in pulling data out of a table

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

Guest

I have 1 table. It has 5 columns of data. 1 column has ID numbers, and
another has Class Room numbers. I am only interested in only 4 of the ID
numbers.

One class room can have many IDs, and one ID may be in multiple class rooms.
This table has about 90,000 lines.

I need to divide up this table, or separate in some way so that at the end I
have the following:
I have only the class room numbers in which those 4 ID numbers fall into,
but I need all the data, including all the other ID numbers also in those
class room numbers.

Am i being clear?
 
Dear Sidney:

Start with a query that is filtered to your list of ID numbers wanted.
Return only the DISTINCT class room numbers for those IDs. Use that to
filter the table to all the class room numbers wanted.

If you have difficulty doing this, write as much of it as you can and post
back here. When I can see all the details I can probably fill in the
remainder.

Tom Ellison
 
Tom,

I ran the query and have the 4 IDs I need (returned about 15,000 lines in
which those IDs appear, all are Distinct Class room numbers). Question is
how do I now take those 15,000 numbers and return all of the data on those
lines?

Thanks for your help
 
Dear Sidney:

I meant to, but failed to specify that I'd like you to post the query you
have to this point. I'll build from there, please.

Tom Ellison
 
Back
Top