Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    50

    Arrow Unanswered: Cross Tab Report

    Hi,

    I have a table with the following structure :

    Col1 Col2 Col3
    --- ---- -----
    A Jack 10
    B JacK 15
    B Jill 5
    C Tom 20
    C Jack 30


    I need a report like following :

    Col1 Jack Jilll Tom
    A 10 0 0
    B 15 5 0
    C 30 0 20

    I hope my question is clear.

    Thanks,
    Ishan

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    See my page on Pivot Queries.

Posting Permissions

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