Access queries/SQL -- Multiple search

Question

Hi

I am trying to create a query / SQL that will find duplicate rows that have any 2 of the 6 fields matching.

ie: Row 1 =   1, 2, 3, 4, 5, 6
     Row 2 =   2, 3, 10, 11, 12, 13

The query should find 2, 3 as duplicates even though they aren't in the same fields.... so long as they match, that's all that matters.

Thanks for your help

Answer 1

Good Morning: 

This forum is for helping customers interoperating with Windows via our open protocol documentation. Your issue does not appear to be related to our protocol documentation. Your question may be better answered by posting in one of the forums at the following link

http://forums.microsoft.com/TechNet/default.aspx?ForumGroupID=93&SiteID=17

---

Regards, Obaid Farooqi