Hi there,

What's a good way for deleting duplicate values from a database?
I've tryed to use the distinct option but thats is not working very well.

My table is containing twenty columns. I have to use a combination of three columns to look for duplicates.
Because only the combination of the three columns delivers duplicate values.

I'm using MS Access.


Hope this is not to confusing.