Thank Lowell. I am nearly there. The latest example you gave 'by saying having anything other than OK' gives the status NOT OK.

I should have mentioned it earlier. This is because i have another status which is PASS (technician test). OK is another double verification to close the item. (final). PASS + OK = OK PASS + OK + NOT OK = NOT OK.

As long as there exist NOT OK in the group of product, overall is NOT OK.

I have change the condition in select statement where Status = 'NOT OK' instead of Status <> 'OK'

Thanks again.