Richard Korts
asked on
Delete Query
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.
Thanks
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.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.