Searching for Triplicate Values

[Elwood Blues]

Does anybody know of a way to find triplicate records? I know that a "!" in a field will find all of the records with 2 or more matches, but I am trying to just view records that have 3 or more matching values in a certain field. I don't know if this is possible, but any input would be appreciated.

[LaRetta]

Hi Elwood Blues,

Since you need to compare each record in a table to all other records, you need an aggregate function. If you create another table occurrence of your table (maybe called 3orMore) and join that 'certainField' to same 'certainField', they will associate. Then create a calculation (type number) with:

Count(3orMore::certainField) > 2

This will produce a 1 (because it creates a boolean) on any records that have two or more OTHER matching entries in that certain field (greater than 2). Keep in mind that searching on this calculation will be slow because it's unstored.

Correction: I was mixing issues by mentioning GTRR and I've removed that portion. You'll need to perform a Find on the 1. Unsure where my head was at suggesting GTRR here.

LaRetta :wink2:

Edited September 10, 2005 by Guest

[Elwood Blues]

Thanks for the help! I tried it out and it works just like you said.