FROM ( SELECT emp_id
, CASE WHEN column1 IS TRUE THEN 1 ELSE 0 END +
CASE WHEN column2 IS TRUE THEN 1 ELSE 0 END +
CASE WHEN column3 IS TRUE THEN 1 ELSE 0 END +
CASE WHEN column63 IS TRUE THEN 1 ELSE 0 END AS result
FROM Skillset ) AS d
WHERE result < 32
if you find that this is awkward, realize that the 63 columns violate first normal form
you would be able to use the COUNT approach only if the table were properly normalized
So I looked it up and have an idea of what FN1 is now. However, I'm not sure what your meaning is. There will only be one row per employee and each row will have all 63 columns. There is no repeating. Can you please clarify what you mean?
Sorry for the trouble, but I'm using Access and CASE does not work. There is switch statement that is meant to do the same thing. Not sure if you can help w/ Access of if this is the correct forum for it ( I looked around and did not see anything specific to Access). But if you are able to help I would greatly appriciate it. Cant figure out how to get switch to work the same.