Thanks both!

They work well. I now have a list unique per each person's address, whic is thebest I could hope for from such a table.

I can now work on...

Can you tell me your table name, and give me some more examples.

Also, can you tell me what happens when you execute the script?

Ok.. then if ID is a primary key, then the script will work, leaving you one record for Banana.

Just change "MyTable" to your table name.

Do you want BOTH Banana records deleted, or just one?

I will assume that you wish to keep one.

This script will only work if ID was a primary key.

delete T1

from MyTable...

Thanks for the replies. I am jus tworking through them now.

A more realistic scenario of my data is as follows:

ID, Cust_id, Title, First, Last, Add1, Town, Prod1, Prod2, Prod3,...

If the records are completely identical, and you wish to be left with just one of each, try this:

delete T1

from MyTable T1, MyTable T2

where T1.dupField = T2.dupField

and T1.uniqueField > T2.uniqueField

Is...