Hi,
I've found no way to fully group and sort the data as I need it to be grouped and sorted once its 'in' Word. This being the reason why...

Dear SSC Eights and SSC Guru
That's certainly cracked the core problem. Many thanks! I now have a table in SQL Server with exactly the right grouping and sort(s).
I need...

Hi,
Actually I spoke too soon. It is nearly working perfectly however the sort order of each 'show' group is in the wrong order. I need it to show the...

Dear SSC Guru,
Thank you! Worked like a charm first time inside SQL Server whether as a view or a query. However I also need to access the resulting recordset outside...

Thanks for you reply Scott. 'Plague' is a polite word for Sharepoint! I was only originally tidying up some loose ends on an SBS 2008 installation, including the SBS console...

Did you grt an answer ever