finding a duplicate entry

#1

we have a database that contains 2500 records. one of the fiels is
social security number. it crashed and was recovered, but when i try
to set a primary key based on social security number it says there are
duplicate entries.

is there a way to query only the duplicate entries so i can correct
this?

thanks!

#2

Use the Query Wizard to create a "Find Duplicate" query.
It's very simple to use.

On 25 Sep 2003 09:52:33 -0700, kemill3 (AT) msn (DOT) com (Ken) wrote:

Quote:

we have a database that contains 2500 records. one of the fiels is
social security number. it crashed and was recovered, but when i try
to set a primary key based on social security number it says there are
duplicate entries.

is there a way to query only the duplicate entries so i can correct
this?

thanks!

#3

kemill3 (AT) msn (DOT) com (Ken) wrote in message news:<12aa1358.0309250852.4ebdba3e (AT) posting (DOT) google.com>...

Quote:

we have a database that contains 2500 records. one of the fiels is
social security number. it crashed and was recovered, but when i try
to set a primary key based on social security number it says there are
duplicate entries.

is there a way to query only the duplicate entries so i can correct
this?

thanks!

There is a find duplicates query wizard in access which will pull out
the duplicates for you. Got to queries, and select new query using a
wizard, and pick the find duplicates option.

Hope it helps

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

finding a duplicate entry

comp.database.ms-access comp.database.ms-access

finding a duplicate entry - 09-25-2003 , 11:52 AM

Re: finding a duplicate entry - 09-26-2003 , 06:01 AM

Re: finding a duplicate entry - 09-26-2003 , 08:19 AM