Dupplicate Primary Key

[OOzy]

Guys/Gals

I have the followig table

Card # Log #
------- ---------
1 43
1 44
1 44
2 66
3 33
4 66
4 99
4 57

As you can see card 1 has log 43, 44 and 44 which is not right b/c my primary key is the card # and the log#.

how can I write an update/append query to remove these duplicate records i.e card# 1 and log # 44

 

[PHV]

Make a copy of your table.
Delete all records.
Create in design view the Primary Key.
Create an append query from the copy into the table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244