Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Transpose? (Access2000)

    I have a table with columns labeled: End_Date, Item and 0,-1,-2,-3,-4,...-12
    the rows are: Unit and ACV
    I'm trying to create a new table that has 3 columns: Date, Item and Value.
    The [0] would be the [End_Date] and the [-1] to [-12] would be DateAdd("M", -1, [End_Date),DateAdd("M", -2, [End_Date)...etc to be placed in the Date field of the new table.
    Is there a function to transpose columns and rows? and would this work in this instance?
    See the attachment for the sample I'm working with.
    Thanks.
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transpose? (Access2000)

    Took a while but I figured it out.
    Attached Files Attached Files

Posting Permissions

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