Filter a table by another table

U

ua2000

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
 
M

Marshall Barton

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.
 
V

Van T. Dinh

Since you really should work on it, I can only give you a hint: Check
Access Help on LEFT JOIN.
 
V

Van T. Dinh

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