Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    66

    Unanswered: can any one help : is it possible to get report of this format

    can any one help

    i have a query which has two fields one is "months" and other is "status"

    is it possible to get data column wise "months" ( jan,feb,mar....)

    and row wise "status" ( good (sum), better(sum) best (sum) )

    example
    these are the months field items

    months : jan feb mar apr may jun

    goodsum: 10 5 3 12 16 11
    bettersum : 5 3 13 5 11 11
    bestsum : 6 15 0 7 6 11

    rowwise data is from status field

    can any pls help
    Attached Thumbnails Attached Thumbnails report.bmp  

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Try to do this via CROSTAB QUERY.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    should be able to
    consider using a pivot table

    the art is going to be marshalling the data.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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