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 IamaSherpa 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
r937 I actually have this problem extended. Now you found all the records that field3 has the same value match. What if I want to find field3 has portion match, for example field3 ------ A100 A1004 A1004-56 A10044a-11 and they are belong to one group just like the former solution. Let say at... -
show records that are not completely duplicated
tried this and works like a champ. 1000 thanks! -
show records that are not completely duplicated
ppl here are too smart and quick, I will try this right away. :-) THX -
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...
