Check mulitple fields and return one value

[Bucephalus]

Hello,

lets say I have a table with five tasks for five employees and each employee's data type is with 'Yes or No'.

I need to have a desired result to check

1.if all the employees have completed that particular task then the result should be 'YES'
2.if anyone employee has not completed that particular task then the result should be 'NO'

so, for each task there must be a check on all the five employee's data type.

I'm attaching a sample to explain things better.


could anyone pls help me on this?
any suggestions?
I'm just a beginner to Ms access.