I figured it out, just like you said, I used MAX around each CASE statement and it ran like a charm. Thanks!