>David,
>As you supplied the sql code in doc it doesn't apply a situation like above. If I understood well if values for vendor, transaction and invoice exist in more than one record and transposed then it's a duplicate. Better show what I understand.

>   Vendor Trans Invoice  Dupval && Unique dup value
>   ------ ----- -------  ------
>1     123   456     789       A
>2     763   636     323
>3     456   123     789       A
>4     123   123     664       B
>5     123   664     123       B
>6     664   123     123       B
>
>1&3 are duplicates. 4,5,6 are another dup. set.

>If this is true then see my previous reply for a solution.
>Cetin

This is correct - DupCheck() does not search for transpositions such as are illustrated. Admittedly, this a more unusual kind of situation. DupCheck() was designed to help in the construction and maintenance of primary and candidate keys in a table, while this is a more specific data integrity issue.