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

[rocky smolin]

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?

 

MTIA,

 

 

Rocky Smolin

Beach Access Software

760-683-5777