Removing duplicate records programmatically

[zhuanyi]

Hello there,
I am just wondering how can I use VBA to remove duplicate records, as identified by the combination of values of certain fields, would be removed from a table.

Thanks!

 

[KeithG]

You could either use an SQl statement or open up a recordset and use its delete method to delete the records. Your question is to generic to give any examples. Can you elaborate?

 

[zhuanyi]

Ok, say basically I have a table that has a clientID, clientFirstName, clientLastName, clientAmtRequired and clientFeeCollected column, the table was generated through the combination of close to 100 tables, and I would like to leave only one record that has the same clientID, clientFirstName, clientLastName and clientAmtRequired even though clientFeeCollected column may contain the value "True" or blank (which is considered as true as well).
How can I do that in SQL?
Thanks a lot!