Kevin,

My first question is why would you want to do this?

It sounds a lot like the Excel reports I am replacing in the new app I am developing.

If you explain your purpose, there may be a better way to accomplish your goal.


>Is there a way (in a single SELECT) to produce results under headings.
>
>When I do a GROUP BY, I want a heading above each group to show the title.
>
>I don't think it can be done without creating a R/W cursor first, then inserting the headers.
>
>Can someone put me right/or advise me on this?
>Thanks
>Kev