>>>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.
>
>Like I've always said, you meet a better class of person.
>
>Well I had to talk to myself as no-one was offering any ideas.

You were just emulating your own Auntie Emma.