Deduping Help Please

[Rene1024]

Hi,

how do I depupe a table in access, I have records that share the same address and for mailing porpuses I need to eliminate duplicate addresses.

What's the best way to do this?


Thanks in advance,

Rene

 

[jdegeorge]

I can't find it right now, but there's a FAQ on one of the many access forums on this site. Check each one out. Sorry I couldn't give you the exact link right now.

Jim DeGeorge

 

[Rene1024]

Sorry,

I've looked everywhere and can't find it, does anybody know an alternative piece of code that i can use?

Thanks again.

Rene.