Is it possible to identify duplicate records using vb6?

[wedd]

Hi, is is it possible to write vba code to identify duplicate records, which help with deduplication in ms access? If so, would you know or any sample code I could use to do this?



Thanks


:friends:

[mohanvijay]

To find duplicate entries in single field use below query




SELECT fldname FROM tblname GROUP BY fldname HAVING COUNT(fldname)>1

[HiTechCoach]

Have you tried the duplicates query wizard?