Hi

I followed the instructions and made the following select statement which worked! So your instructions are obviously idiot-proof. I’ve copied the result set of my first Union All statement...

Hi Wayne

My apologies. I'm new to posting questions. Also I'm just a simple support person who has been assigned to write some reports, not a DBA; I don't know how...

Hi Vince

Thanks for coming back - I hope i'm not keeping you up. Some success, some failure - I can't block out a row and choose visibility (I wonder if...

Hi Vince

Thank-you for your work - it's most appreciated. I understand where you're going but have two problems.

1. I got the sorting working as you suggested but ony by manually...

Hi hallidayd

That solution is beautiful in it's simplicity. I have adapted it to my query and it's working brilliantly.

Much appreaciated.

Paul

Hi drowlfs

Many thanks - that indeed did work. Your help is most appreciated.

Paul