How do I VBA....to go through a recordset and eliminate duplicate

I have a recordset and need to eliminate the duplicates before dumping the
recordset, What Vba verbage can I use?

Could you do a SELECT DISTINCT when building the recordset?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"marthasanchez" <marthasanchez@discussions.microsoft.com> wrote in message
news:14FC3603-B8D9-45BC-BC32-7F6F76381EED@microsoft.com...
> I have a recordset and need to eliminate the duplicates before dumping the
> recordset, What Vba verbage can I use?