What I do use the Find Duplicates Query Wizard to create a query. Then change the query type to a delete query. Then I run this query before running the report.
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.
dphan
this may help. i find that locating and deleting duplicates is more of a process than just a click. i use a modified "find duplicates Query" along with a form i created to show the possible duplicates then use a double-click on the box in form with code to search the table and bring up only the duplicates then decide which to delete ...manually....the main problem i see with Auto-deleting anything is that, if for some reason the program has a problem u may delete data that u really wanted.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.