Merging tables

[PCOR]

I am in a very difficult position.
In this office TWO people are responsible for inputting data into an access
database. They both work separatly.My job is to merge both tables(called
MASTNAME) and to eliminate any duplicates.
Can any one tell me how to do this properly and quickly?
Thanks

 

[Ron Hinds]

I am in a very difficult position.
In this office TWO people are responsible for inputting data into an access
database. They both work separatly.My job is to merge both tables(called
MASTNAME) and to eliminate any duplicates.
Can any one tell me how to do this properly and quickly?
Thanks

I would use the Find Duplicates Query Wizard to create the base SQL. Link to
each of the user's tables, then run the Wizard against those two. Modify the
SQL it produces to INSERT only one copy of the duplicated rows into the main
table. Save that Query and run it each time you need to merge.

 

[PCOR]

Thanks a pile but could you provide more detail as I am new at this stuff
Thanks]