Column Summary

HI,
am new to sql and trying to write a query to summarise data in a table.The table contains a list of documents, their type and author
DocName DocType Author
Name1 letter tom
Name2 essay rick
Name3 essay rick
Name4 letter arnold
Name5 letter tom
Name6 poem ed
Name7 letter tom
...etc

and i wish to do a breakdown of the form:

DocType Total Docs Tom Arnold Ed Rick
letter 54 21 14 14 5
essay 78 18 36 15 9
poem 18 3 6 6 3

have tried a few select queries but have come up short...any ideas?Look up Cross-Tab Reports in Books Online or search here. This has been covered several times and you can find some good examples in each location.|||Originally posted by Paul Young
Look up Cross-Tab Reports in Books Online or search here. This has been covered several times and you can find some good examples in each location.

Cheers Paul, much appreciated