Results 1 to 3 of 3

Thread: Column Summary

  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unanswered: 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?

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    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.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Sep 2003
    Posts
    4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •