I have an Access database table (on a web server).
There are 4 identical records, I want to delete 3 & keep 1.
Is there a way to do this? If I do "DELETE Orders where......." all the where criteria are the same so it will delete ALL, which I don't want.
Of course I recognize I can save the data from 1 & then re-insert, but that's a pain.