Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
show records that are not completely duplicated
Let say I have 4 fields, field1 field2 field3 field4 1 2 3 4 1 2 3 4 1 2 3 4 2 6 3 5 1 1 2 1 1 1 2 1 5 9 7 4 7 7 9 7 7 7 9 7 7 7 9 5 7 8 9 10 8 8 6 8 8 8 6 9 I want to show all records that field3 has duplicates but if all those records of all fields are the same, then do not show any of...
