Finding alike entries in 2 tables???

[phishbfm]

i've got two tables of data that i imported from excel. both tables have a field for account numbers. I just want to be able to see which account numbers are the same in each, which ones are in table 1 that arent in table 2, etc.. i had access create a primary key since some of the account numbers are repeated in each table.

does anyone know how i can do this? ive tried running a query with those two tables...but i don't think the joining worked because when i set [table1].[acct]=[table2].[acct] nothing came up, and i know for a fact some are the same.

 

[Mile-O]

Use the Find Duplicates Query Wizard.

 

[phishbfm]

i dont see this option

 

[monkeytunes]

Make sure you're in "Queries" in the database, then click on the "New" button. A window will appear with a list of some possible queries you can build/ways to build queries, including "Design View", "Simple Query Wizard", etc.

The one you want is "Find Duplicates Query Wizard"

 

[phishbfm]

great, that feature is not installed....and my company has an IT department that is hell to deal with.