Hi All, I am trying to find duplicate records based on two fields so my fine criteria are:

QItemSerial !

Type 1

It is finding duplicates but also finding records that are not. What am I doing wrong. The screen shot below has the records sorted by QItemSerial

The way your find works is this: first, it finds records with duplicate values in the QItemSerial field. Next, it finds records with duplicate values in the Type field. Finally, it returns the intersection of the two sets. So for example, if you had 3 records in a table:

Field A	Field B
A	1
A	2
B	2

your find would return a found set of one record:

A

2

because that's the only record that has a duplicate value in both fields.

If you want to find record that have matching values in both fields, you will need to define a calculation field that combines the two fields, e.g. (result is Text) =

 QItemSerial & "|" & Type

then search for duplicates in this field.

 

Edited September 8, 20196 yr by comment

Thank you comment, that solves it