Creating new list from two lists with specific data from both

  • Thread starter Thread starter Rookie in Need
  • Start date Start date
R

Rookie in Need

How do I compare List A to List B and create a third list that has specific
data from each of the original lists?

Specifically, I have one list of individuals with email addresses (LIST A)
and another list (LIST B) that has some of the individuals from list A
without their email addresses. I want Access to find all individuals in LIST
A that also appear on LIST B then create a new list, which would be LIST B
with the email addresses added where matches occurred.

I presume this can be done, but I'm way over my head here. Can anyone help?
 
Presumably you have some field(s) in common between the two lists (other
than name: name is a terrible thing to join on!)

If you do, create a new query.

Add the two tables to the query, and join them on their common field.

Drag the fields you want from each table into the grid and run the query.

All that'll be returned is what's in common between the two lists.
 
I know this is ridiculous, but how do I get two tables into a query? I seem
to only be able to open one table at a time... As I said, I'm a real rookie.
 
Back
Top