Delete Double Entry From Access DBF Table

Hi Friends

* I want to delete a double entry in column REG
But don`t success .any one help me I sending DBF file view as attached files pls so I very thanks full if any one help me. if any one make Sample file on access so plese send on masifnaz@gmail.com
Attachment 630


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxUbeYSvsBH2Gianox4AaABAg. 9VYH-07VTyW9gJV5fDAZNe
https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxLtKj969oiIu7zNb94AaABAg
https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgyhQ73u0C3V4bEPhYB4AaABAg
https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgzIElpI5OFExnUyrk14AaABAg. 9fsvd9zwZii9gMUka-NbIZ
https://www.youtube.com/watch?v=jdPeMPT98QU
https://www.youtube.com/watch?v=QdwDnUz96W0&lc=Ugx3syV3Bw6bxddVyBx4AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

Masif, why would you call that as a double entry? The data seems to be a raw data that isn't normalized. If you want to just select data for one column, without having any duplicates, you could use the query

Code:

---

SELECT [Column_Name] FROM [Table_Name] GROUP BY [Column_Name]

---