Delete Dupes Question

[Guest]

I read many related questions but couldn't quite come up with the answer. I
think there's an easy solution, but I'm pretty new to Access.

I have two tables, "Arcs" and "Custs". Each table has only two fields:
"Arcs" has Arc_Nbr and Country.
"Custs" has Cust_Nbr and Country.
Both Arcs and Custs have some duplicates between the two. I'm trying to
create one table that is a combination of these two which also has only two
fields (in this new table there will be "Track_Nbr" and "Country", where
"Track_Nbr" is either the Arc_Nbr from the "Arcs" table or the Cust_Nbr from
the "Custs" when there are no dupes. When there is a dupe it doesn't matter
if it's pulled from the "Arcs" or "Custs" table.

I've managed to create a table that has the dupes in it, but I don't know
how to eliminate the dupes. Any thoughts?

 

[Guest]

The easiest way I have seen is done in two steps....

if you open the help in access and type in "Delete duplicate records from a
table"
it will give you the step by step walkthrough

 

[Guest]

Thanks. I now have created sql to accomplish this which seems to work.
However when I select "Make Table" query it's asking for at least one
destination field. If I add a field in the design view, it changes the sql.
Can you tell me how to add a destination field while keeping the sql? Thanks.