I have tried using the Find Duplicate query. I have gotten the results.
How do i change the query type in code? I want the report to automatically remove the duplicates. Plus, when i manually changed the type into delete query, and ran it, it deleted everything in my table.