create a primary key in an existing table

[leah_603 via AccessMonster.com]

I encountered problem when i tried to create a primary key in an
existing table which does not have one yet. There are too many records
in it and it's hard to find out which one is 'duplicated'.
I'm not sure whether, if there is any duplicate records in the table.
How can i solve this problem?


Thanks


leah_603

 

[David F Cox]

If you run a group by query on the fields that you are concerned about, do a
count, and select those with a count greater than 1 it will show you
duplicates.

If you have duplicates you can then join this query to the table in another
query and identify the duplicate records.

 

[John Spencer]

Use the query wizard to create a duplicates query based on your table and
the field you want to make the primary key.

 

[leah_603 via AccessMonster.com]

Thanks for the replies.
I guess the problem is now solved.
Thanks again.

leah_603