duplicate records

[Guest]

Hi,

I have a database that contains employee names and company address details
however there are a number of duplicate records.

I have used the 'find duplicates' function in queries and have over 2,000
dupes!!

I could manually delete all relevant duplicate records but there must be an
easier way.
The table contains records that have the same company name but different
employee names, there are also some companies that have employees with the
same surname.

 

[Guest]

I would recommend splitting your table like --
Company -
CompID - autonumber - Primary Key
Name - text
Addr1 - text
Addr2 - text
City - text
State - text
Zip - text
Zip-plus - text
Phone - text (main business number)
Type - text
Remarks - memo

Contact -
ContID - autonumber - Primary Key
CompID - number - long interger
LName - text
FName - text
MI - text
Addr - text (Mr, Mrs, Miss, Ms, etc)
Phone - text
Ext - text
PerPref - text (the name prefer by contact)
Funct - text (ordering, shipping, billing, etc -- or build a table for these
using ContID)

Function -
FunctID - autonumber
ContID - number - long interger
Funct - text
Remarks - text

Set relations Company.CompID one-to-many Contact.CompID and Contact.ContID
one-to-many Function.ContID

 

[Guest]

Thanks for your response.
I am a bit of a beginner when it comes to Access however I will give it a go
tomorrow when I am at work.

I will let you know how I get on.