create a primary key in an existing table

  • Thread starter Thread starter leah_603 via AccessMonster.com
  • Start date Start date
L

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
 
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.
 
Use the query wizard to create a duplicates query based on your table and
the field you want to make the primary key.
 
Thanks for the replies.
I guess the problem is now solved.
Thanks again.

leah_603
 
Back
Top