Removal of dup SSN# from a report. Duplicate records with same

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to remove duplicate records with same SS# to create report without
duplication. I would like Primary Key to be the SS#.
 
I'm a little confused. By definition, a primary key can not contain dupes.
Do you have a table with SSN as a primary key?
 
Yes I have various tables with ssN I would like for that to be the pk however
it's not working out for me. I have over 8000 records with last name, fname,
ssN. Some are dup records. I NEED TO REMOVE THE DUPS IN THE TABLE AND JUST
HAVE ONE Person per SSN:
 
If you go to Queries > New > Find Duplicate Queries Wizard, you can select
the table name. Then select the field containing dupes (SSN). Then you select
the fields you want to see in your output. You can then manually delete the
duplicate records from the results of that query.

This will be a permanent deletion, so be sure to make a back-up copy of your
table in case things don't go as planned.

Regards
 
If you have records that are complete dupes, there is another solution.
Create a Make-Table Query.
Select the fields that you want in the new table: last name, first name and
SSN.
Open the queries property box: View > Properties
Click in the upper pane of the query box to view the query properties.
Set the Unique Values property to "Yes."
Run this make table query and it will only save those records with unique
values to the new table.

HTH
 
Ken,
I have a table with some duplicates values in a certain field. I want to
only keep one record (in a new table) for each of these records that have
duplicate values in this field. I do need all fields in original table to be
in this new table!
I don't think what was written on this thread show how to do this.
Thanks,
Don
 
Back
Top