removing 1 of the duplicte rows

[neilb]

Hi

I have a table that contains duplicate rows of the same data apart from the date entered.

What I need to do is remove any duplicate rows apart from the first one entered.

I have tried delete query but can not figure out the criteria to do this.

Is this possible?

 

[SydneyGeek]

How many duplicate rows do you have? If not too many, try this:

Create a dummy field (integer) with no data.

1. Create a Duplicates query (use the Wizard). Include the dummy field.
2. Now sort the query if you need to get all duplicates together. Run down the list and put a 1 next to the first occurrence of each duplicate. (Use the dummy field that you created in step 1)
3. Right-click on a 1 and Filter Excluding Selection
4. Now you can select all and delete. Long-winded, but it works.

Denis