Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006

    Unanswered: Help with query. rows to columns

    Hi all,

    I have data (lets say in a view)
    in the form:

    Project Ref Type Acts ETC
    PROJ1 UK123 Des 50 30
    PROJ1 Thai456 Des 20 15
    PROJ1 UK321 Dev 25 0
    PROJ2 UK756 Des 5 56
    PROJ2 UK835 Dev 30 40

    I need to group like Projects together and transpose the figures as well as sum.
    1 line per PROJECT is required
    Project DesRef DesActs DesETC DevRef DevActs DevETC
    PROJ1 UK123,Thai456 70 45 UK321 25 0
    PROJ2 UK756 5 56 UK835 30 40

    Can anyone suggesthow I might acheive this?
    As you can see any like types in the same Project must be summed together than their repective Refs comma seperated.
    Then the figrues for the Des Types must be shown over the nect 2 columns
    Followed by the same for the Dev types.

    any ideas?

    Thanks in advance,

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL

    Thumbs down

    Yes, my sugestion is for you to do some research.
    This question has been posted again and again, use the "search" forums option.

    Or query your friend google or ask tom

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Oct 2006

    Thumbs up

    thats great!
    thank you so much for your help.

Posting Permissions

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