[AccessD] Finding Duplicate Records when there are more than 10 fields

rocky smolin rockysmolin2 at gmail.com
Wed Oct 21 10:59:58 CDT 2020

Dear List:


I have a client running a db I made for him which has a table of 30 fields.
He wants to identify duplicate records meaning all 30 fields (excluding the
PK of course).  But the duplicate query wizard has a limit of 10 fields.  So
I think this needs a piece of VBA code.


Does anyone have a good procedure for doing this?





Rocky Smolin

Beach Access Software





More information about the AccessD mailing list