Duplicate Records

[Guest]

I have a database with duplicate records. I want to do a make-table query, I
think, to remove the duplicate records but I want to retain the records
deleted in a separate table.

I also need to find records with null fields and move to a separate table.

Any guidance would be appreciated!

Bev

 

[John Vinson]

I have a database with duplicate records. I want to do a make-table query, I
think, to remove the duplicate records but I want to retain the records
deleted in a separate table.

Create the new table empty, and use an Append query to populate it
(rather than using a make-table). Set the Unique Values property of
the append query to True.

To get the duplicates which were not transferred, you'll need SOME
unique field in the table; if you have three records which are
absolutely identical in all fields, there's no way for Access to pick
out two of them (the "duplicates") and ignore the third (the
"original"). A FindDuplicates query built with the query wizard (based
on your original table) will at least display which records are
duplicates, if that is what you need.

I also need to find records with null fields and move to a separate table.

Again, just use an Append query; use a criterion of

IS NULL

on the fields in question.

John W. Vinson[MVP]