Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013

    Unanswered: Group multiple rows into one row


    I have an access table containing sales information for each item on a weekly basis. For example for item 001 I have sales from week 1 to week 52 into multiple rows. I need to create a query which groups the result into one row displaying quantity results per week into 52 consecutive columns.

    Attached is an extract of the table and an Excel Sheet of how the query result should be displayed.

    Thanks for your help

    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    use a group by clause to marshall the data and then use that in a pivot table / crosstab query
    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