Thanks for your reply! I finally found it located in Reporting Services but it was a hidden attribute. All is good

Doug,

Removing the Top1's did not change a thing. I personally despise the way he wrote this code. It's nothing but confusing as heck! I will try to reconstruct it in...

Ugh! That makes sense! I am teaching myself SQL and I had already written the code when a guy from our software developer told me I should do it that...