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
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
To find duplicate entries in single field use below query
SELECT fldname FROM tblname GROUP BY fldname HAVING COUNT(fldname)>1
Have you tried the duplicates query wizard?
Boyd Trimmell aka HiTechCoach
Microsoft Access MVP -2010-2015
Programming: Nine different ways to do it right, a thousand ways to do it wrong.
Binary--it's as easy as 1-10-11