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

[marthasanchez]

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

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> I have a recordset and need to eliminate the duplicates before dumping the
> recordset, What Vba verbage can I use?