>Ne'er mind! I've sorted this. I do 2 passes - one for the prev period and one for the curr period, i.e. each with only half of the CASE statement.

When you talk to yourself, at least you know you can't complain about the company. And you got your (almost) undivided attention.