Updating values in a table based on the combination of values in the columns in the same table

[rashokku]

First of all the thanks for your help. Attachment is the spec which I am explaining below.



Columns in table:
--------------------
MemberID (Primary Key):
COL1
COL2
COL3
COL4
COL5
COL6
COL7
COL8
COL9
COL10
COL11
COL12

I have 13 columns in a table in MS Access database as above. I would like to update the columns based on the combination as in the attached specification.
For example, if the combination is "9, 10, 11, 12" (if atleast four or more of the 12 columns has all the four values in any order - let us say
COL1 = 10, COL2 = 9, COL3 = 12, COL4 = 11, COL5 = 12 then update the columns with 8.

Attachment has combination and the values to be updated. Another example, from attachment/spec. If the combination is 111, 112 (atleast two of the columns having each of the values)
then update the columns with 110.

Anybody can provide insights on the approach.

Thanks,
Ram

[davegri]

This looks pretty tough. Each record in the table would have to be examined for each of the 31 combinations and updated appropriately. Do any of the records have multiple combinations across the 12 columns? That would double or triple the required checking and updating. And then, how many records are in the table?
The coding complexity boggles the mind and the computer execution time required to accomplish the results might be unacceptable if the table contains more than a few dozen records.
If I have this wrong, anyone else have an epiphany - or better yet, an algorithm?