Filter a table by another table

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

Guest

I'm having a problem that shouldn't be too hard to solve....for someone with
more Access experience. I have a table of about 60,000 records with a couple
hundred fields each. One of the fields is telephone number. I have a
seperate table with a list of about 10,000 telephone numbers. I need to
filter the first table (60,000 records) by the second table (10,000 records)
using the telephone number field. I'm working on this for a college project
so any responses received quickly would be GREATLY appreciated!

ua2000
 
ua2000 said:
I'm having a problem that shouldn't be too hard to solve....for someone with
more Access experience. I have a table of about 60,000 records with a couple
hundred fields each. One of the fields is telephone number. I have a
seperate table with a list of about 10,000 telephone numbers. I need to
filter the first table (60,000 records) by the second table (10,000 records)
using the telephone number field. I'm working on this for a college project
so any responses received quickly would be GREATLY appreciated!
Click to expand...


Use a query that has an Inner Join of the two tables.

BTW, any table that has more than about 30 fields is bound
to be improperly normalized.
 
Since you really should work on it, I can only give you a hint: Check
Access Help on LEFT JOIN.
 
.... and INNER JOIN since I am not sure whether you want to select Records
with matching TelNos or without matching TelNos from the second Table.
 
Back
Top