What i want is to find duplicates like this-

Field1 Field2 Field3
cust1 cust2 cust3
cust4 cust5 cust6
cust2 cust7 cust8 (dupe cust2)
cust9 cust4 cust10 (dupe cust4)
cust11 cust3 cust12 (dupe cust3)
cust2 cust2 cust 1 (dupe cust1)
cust13 cust6 cust14 (dupe cust6)



"John W. Vinson" wrote:

On Mon, 1 Mar 2010 11:58:03 -0800, gil_wilkes
wrote:

How can i find duplicate data across 3 fields.

Thanks in advance.

You'll need to ask a clearer question, perhaps with an example. Duplicates...
within the fields? across records in a table? duplicates between two tables?

More info please!
--

John W. Vinson [MVP]
.