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?

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

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