Kevin,

how about a UNION...

SELECT 'C' + SPACE(x) AS Field1,
'F' + SPACE(y) AS Field2,
'P' + SPACE(z) AS Field3
FROM table
UNION
SELECT ....

>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

HTH,

Phil