Without more information such as table and field names, sample records,
desired output, etc; I can only suggest you print them out, apply your
specifications on what is a duplicate across 3 fields and highlight them with
a marker.

Are you looking within single records? Do all three field have to be exactly
the same? Please provide more information.

--
Duane Hookom
Microsoft Access MVP


"gil_wilkes" wrote:

How can i find duplicate data across 3 fields.

Thanks in advance.