>I need to sort out the records by similairity of 4 fields, eg.
field1 field2 field3 field4
1 2 3 4
0 5 6 4
5 3 4 2
5 6 7 8
so, the sort result sould be
1 2 3 4
5 3 4 2 Because 2,3,4 match 1st record, 3 similairity
0 5 6 4 Because 5,4 match 2nd record
5 6 7 8 because 5,6 match 3th record
>Anyone have solution for this.
In your example, it appears that each of your four fields can contain a value in the range 0 to 8.
1. What is the actual range of values?
2. What is the data type of the four fields (and size if character)?
3. Do you also have a field that is Primary (if yes what is it)?
censored.