Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    2

    Unanswered: Restructure Access data

    Wish to transform data
    id Question response
    1 1 ###
    1 2 ###
    1 3 ###
    2 1 ###
    2 2 ###
    2 3 ###
    to
    id Q1 Q2 Q3
    1 ### ### ###
    2 ### ### ###

    I think maybe PIVOT Tables will do this, but I'm new to ACCESS and have time pressure. Can anyone help?
    Thanks,
    hjl

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    Depending on the version of Access that you're using, look in the Help file for Crosstab queries.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  3. #3
    Join Date
    Jul 2011
    Posts
    2

    Restructure Access data

    Thanks.
    I'll read up and then try that
    hjl

Posting Permissions

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