G
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?
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?