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

[Charlotte Foust]

I don't have any code on hand, but I recall building that kind of search in
an application doing data cleanup.  I addressed it by concatenating the
fields into a pipe (|) delimited string and comparing strings.

Charlotte Foust
(916) 206-4336


On Wed, Oct 21, 2020 at 9:00 AM rocky smolin <rockysmolin2 at gmail.com> wrote:

> 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
>
>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>