Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Nov 20, 2021

Delete Duplicates (leave 1)

Hello, I have duplicates in my table and I want to delete only 1 of them. I have searched on the net for some code and found the below and fashioned it to my case.  I have an error though and it appe...
access
  • isladogs's avatar
    isladogs
    Nov 20, 2021

    Tony2021 

    Hi
    I'm just about to go out but have a look at the 2 example apps in the attached zip file which show two different approaches to this

     

    Hope one/both are of help

isladogs's avatar
isladogs
MVP
Nov 20, 2021

Tony2021 

Hi
I'm just about to go out but have a look at the 2 example apps in the attached zip file which show two different approaches to this

 

Hope one/both are of help

  • Tony2021's avatar
    Tony2021
    Steel Contributor
    Nov 20, 2021

    isladogs 

    very nice.  works great!  I also like it that there are 2 fields to test on.   Thank you very much. 

    • isladogs's avatar
      isladogs
      MVP
      Nov 20, 2021
      Glad it worked for you. Sounds like you used the simpler version based on a single query. Is that correct?

Resources