Click to See Complete Forum and Search --> : Finding possible matches


MaMaMiYa
09-04-2008, 05:47 AM
Hi, lets say I have the following 7 records in my database

ID Model
-- ------
1 400
2 400FL
3 400 FL
4 ABC
5 SGH500
6 SGH-500
7 SGH 500

How is it possible if i could select out the rows which are of possible match to some other rows?

E.g. IDs 1, 2 & 3 are possible matches of one another and IDs 5, 6 & 7 are possible matches of one another. ID 4 will not be displayed in the result.

Btw, I am using MS Access.

Thanks a lot in advanced