Use info from one table to search in another

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

Guest

I have created two tables in the same database. I would like to use one
table's information records to search in another table. I have a list of
1044 numbers that I need to match up to their corresponding info in another
table with over 650,000 records, and ideally, have a new table (or something)
created with just those 1044 results. Is there anyway to do this? Without
entering each record individually? I am a new user...

nowuome
 
Are you saying that your first table has the values you are looking for, and
the second table has those values in some of the records?

If so, create a new query, add the two tables, join them on the common
field, select what field values you want displayed, and run the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top