Deleting duplicate record

[EMILYTAN via AccessMonster.com]

May I know how to actually delete the record when it duplicate and only
keeping 1 record...

For example

I have 3 record which is exactly the same:-

PK PartNumber
1 1111-1111
2 1111-1111

From the situation above I only want to keep 1 record....
May I know the way?

 

[Trever B]

Hi,

Could go about this in many ways:-

1) Append all records to a new table with unique record set to Yes No Dups)

or

2) Run a groupby query this would Show each record only once. Then you
could make a table.

Or

3) The query will be based on all dup records. Run an sql delete query
deleting all records like current field except for the ID of the current
field.

Trust this gives you a pointer in which direction to go.

Need any more help just ask.

Trev