Thread: How do I VBA....to go through a recordset and eliminate duplicate
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 380
Default 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?


Reply With QuoteReply With Quote