14 thoughts on “Lecture 17: MS Access Query Wizard – remove duplicate records


  1. đăng ký w88


  2. đăng ký w88

  3. Very good!!! finaly I know how to remove double records with a query. Ik was looking for it for years and Microsoft never helped. 🙂 You did and I learned it in 5 minutes.


  4. đăng ký w88


  5. đăng ký w88


  6. đăng ký w88


  7. đăng ký w88


  8. đăng ký w88


  9. đăng ký w88


  10. đăng ký w88


  11. đăng ký w88


  12. đăng ký w88


  13. đăng ký w88

  14. contains differents sheets and in each of them, I have duplicate rows. The issue is that the information in 2 duplicates records are not the same from a column to another unless Last Name and First Name.
    I have been able to identify duplicates records and store them in a temporary table. I have then deleted them from the initial table and want now to Append only one of each duplicated records from teh temporary table. Need your help for that or any other solution.


  15. đăng ký w88


  16. đăng ký w88

  17. Thank you, I was looking for days to find how to prevent duplicate data when i import from excel to access, followed your steps and it worked great, once more thank you

Leave a Reply

Your email address will not be published. Required fields are marked *