>>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. If I hadn't replied and said it's sorted then it may have wasted other people's time and effort trying to solve it, and thus would have been very rude.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.