I did not realize I was in a comedy forum, lol.

Problem was solved by putting it together in chunks into query window one after the other instead of...

Yes that is what I am attempting to get to work Thom, but it is not excepted.
If I put portions 1&2 or 3 and 4 together it will run...

Sorry 4

Hi Thom,

Basically it would be 3 when statements together like below.

CASE WHEN Activity_Active_8.RBLK IN ('21' ,'22' , '23'...