combining duplicate records

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

Guest

I have one database with one table that contains a field named EIN #. The
data in this table has been duplicated due to formating in the EIN # field as
XX-XXXXXXX and XXXXXXXXX. The records have the same numbers, one with the
dash and the other without. I need to combine these duplicate records into
one. These records also contain other fields that need to be combined. Is
there a way to accomplish this?
 
SRQOPS said:
I have one database with one table that contains a field named EIN #. The
data in this table has been duplicated due to formating in the EIN # field as
XX-XXXXXXX and XXXXXXXXX. The records have the same numbers, one with the
dash and the other without. I need to combine these duplicate records into
one. These records also contain other fields that need to be combined. Is
there a way to accomplish this?
Click to expand...

sure, maybe with a messy sql statement, or use some vba to search through
all the records, match them up and delete the duplicates in the wrong
format.
 
Back
Top