combining duplicate records

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

 

[Dave]

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?

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.