Remove duplicates ?

[dphan]

Is there a way to remove duplicate records in access w/o manually pasting with the "structure only" option ?

I need to automatically detect and remove duplicate records everytime a report is opened.

Thank you all in advance. =]

 

[tledwards]

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.

 

[dphan]

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.

 

[cghoga]

have you tried adding the word "distinct" to your original select statement that generates the query?

i.e. Select distinct [ID] from.....

To make this change, open your query in design view, go to View, SQL View and change it there.

hope this helps.

 

[DeRat]

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.