Comparing 2 Lists

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

Guest

Okay I know this is probably so basic it's pathetic but I've forgotten
everything I learned about Access years ago. I have two lists in 2 separate
Excel files. They are each single column lists, both consisting of product
names. Names from one list will intersect with names from the second larger
list.

I can import each list into Access and create 2, single-field tables. How
do I structure a query (or queries) using the data in those tables to find:
1) Products that are found in both List A and List B, 2) Products that are
found in List A but not found in List B and 3) Products that are found in
List B but not found in List A?

Thanks for helping a newbie....
 
Confused.
Using the query design grid for simplicity, place both tables in the
query, and join them ProdName to ProdName. Now click on the Join line, and
you'll see the three types of joins available to you. They are just as you
indicated...
Inner Join = Only those values in table1 that have a match in table2
Left Outer Join = Show ALL from table1 and ONLY those in table 2 that
match
Right Outer Join = Show ALL in table 2 and ONLY those in table 1 that
match.
hth
Al Camp
 
1) use an INNER JOIN on the tables to find values-in-common
2 and 3) use the query wizard to create a "Find Unmatched Records" query,
one query for each table.

hth
 
Back
Top