Appending To A Table with Unique Records

[Guest]

I have a table with approximately 125,000 records. After manipulating the
data, I ran a find duplicates query using all 5 columns as the main key. This
query returned approx. 26,500 duplicate records. I next created a new table
with all five columns as the primary key (no duplicates). When I ran an
append query to put the unique records from the original table into the new
table, my key violations were approx. 80,000. Why is there such a difference
between the 26,000 duplicates from the Find Duplicates Query, and the 80,000
from the Append query? Is there a step that I am missing?

Thank you for you time!

 

[Guest]

Hi Stoshu,

I can take a guess. But, I won't.
This is what I would do. Create a DISTINCT Query using those 5 columns
(that made up your Primary Key).

SELECT DISTINCT PKey1, Pkey2, PKey3, PKey4, PKey5 from Table;

That will give you an unique record count. That is telling you how many
unique records there is in your table. Then use make table query to make a
table based on above query. Then you need to decide what to do with your
dups.