Delete Duplicates

  • Thread starter Thread starter mission2java_78
  • Start date Start date
M

mission2java_78

Guest
I never did this before..but does anyone know how to create a delete duplicate query? if so got examples or know how?

Thanks,
Jon

Never mind..im stoopid :)..I need a make table query which I can do.

Jon
 
Last edited:
Jon,

Basically, you make 2 queries. Query 1 will Select duplicates. Query 2 will include Query 1 and delete the result.

RichM
 
RichMorrison said:
Jon,

Basically, you make 2 queries. Query 1 will Select duplicates. Query 2 will include Query 1 and delete the result.

RichM

Makes perfect sense,

Thanks,
Jon
 

Users who are viewing this thread

Back
Top Bottom