Delete Duplicates

[mission2java_78]

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

 

[RichMorrison]

Jon,

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

RichM

 

[mission2java_78]

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