Results 1 to 3 of 3
  1. 06-20-2011, 12:04 PM #1
    nkpriya
    nkpriya is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    3

    unpivot in ms access?

    Can we use unpivot in MS Access? I am trying to use rearrange data from columns to rows but MS Access is throwing syntax error when I am using unpivot.
    I know that we can use Union All, but there is a microsoft limitation for not using more than 16-join. I have 12 linked tables from sharepoint lists and I created a join table using 12 union all function. Now, I want to normalize this table as I have columns like this:
    Manager|Worktype|Jan Hrs|Feb Hrs



    I need Manager|Work Type|MonthName|Hrs

    Please help!Thanks
    Reply With Quote Reply With Quote
  2. 06-20-2011, 12:59 PM #2
    boblarson
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Nope, Access doesn't offer UNPIVOT. That is only available in SQL Server 2005 and above.
    Reply With Quote Reply With Quote
  3. 06-20-2011, 01:45 PM #3
    nkpriya
    nkpriya is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    3
    Is there anyway to achieve this functionality?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums