@GREEK....your solution does not work due to what @benbizell stated, if i change it to =3 then the THEN statement works. so you are both right. @benbizell you said: Since the original data...
@ben.bizzell yes, i changed the query after writing text description. so instead of count >=4 it is count>=1. But regardless of the data set ,my question is why...