Duplicates

[jen]

Hello.
In a database that has over 4000 records say of members, how can you avoid
entering the same member twice?.
I did a query on duplicates and found that there were around 200 duplicates.
These members have to have a full first name and full surname and their
contact has to be either address or email.
The database is mainly for mail shots and invitation purposes.
The problem is firstly to get a better idea of the correct number of
members, but mostly so as not to send members more than one mail shot.
Please help.
J

 

[Guest]

First copy table as a safety measure. Next delete the duplicates.
Open the table in DESIGN view. Highlight the field that will be the basis
of your key - Membership number - OR - FirstName, LastName, StreetAddress,
etc. Click on the Key icon on the toolbar. Save.