Hi, I need a little help with an access query I'm trying to get working. I'm not a frequent Access user by any means.
What I have is a db with two tables, one with a list of names and ID numbers, and other with another list of names. What I want to do is run a query that will find the duplicate names between each table, and output that list with the ID #s from the first table.
I've tried using the "find duplicates" pre-made query, but it seems to be outputting duplicates from within the first table, which is not what I want. I only want names that are duplicates between both tables.