Queries for thousands of records

  • Thread starter Thread starter CD27
  • Start date Start date
C

CD27

If I overlooked this topic being discussed previously I apologize.
Basically, I have table in Access 2003, that contains an ID field
(800,000+ numerical IDs). I have a list of about 5,000 IDs which I
need to extract/filter from the 800,000 + IDs. I am at a lost of how
to pull such a large number without doing it manually 5,000 times.
What would be the best way of doing this?

Thank you

CD
 
CD27 said:
If I overlooked this topic being discussed previously I apologize.
Basically, I have table in Access 2003, that contains an ID field
(800,000+ numerical IDs). I have a list of about 5,000 IDs which I
need to extract/filter from the 800,000 + IDs. I am at a lost of how
to pull such a large number without doing it manually 5,000 times.
What would be the best way of doing this?

Thank you

CD
Click to expand...

Is this list in another table? If so you just create a query joining those
two tables on the ID field.


SELECT MainTable.*
FROM MainTable INNER JOIN SecondTable
ON MainTable.ID = SecondTable.ID

A query like above will return all records from the big table that have a
matching ID in the smaller one.
 
Is this list in another table? If so you just create a query joining those
two tables on the ID field.

SELECT MainTable.*
FROM MainTable INNER JOIN SecondTable
ON MainTable.ID = SecondTable.ID

A query like above will return all records from the big table that have a
matching ID in the smaller one.
Click to expand...

Thank you for your quick reply. I don't know why I didn't think of
doing that.

Have a good day.
 
Back
Top