Thanks guys. With your help I got it to work. The problem was that I was using one CASE statement to try to display 3 conditional columns. I...

Thanks. I actually did have an END in my real query but neglected to include it in the shortened version for this post. I just added END and...

I actually understand how/why this example works. Thanks!

Thanks much everyone! Wow - I don't think I have ever got so much good help so quickly on a support forum before. There isn't a date field...