User Profile

Collapse

Profile Sidebar

Collapse
Jeremiah
Jeremiah
Last Activity: Jul 6 '06, 06:18 AM
Joined: Jul 5 '06
Location: Belgium
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Jeremiah
    replied to Convert rows to columns
    in Access
    I would like to save it in a table.
    Thanks,
    Jeremiah...
    See more | Go to post

      Leave a comment:

    • Jeremiah
      started a topic Convert rows to columns
      in Access

      Convert rows to columns

      I have a database with monthly data for each client, each row another month. How can I convert these rows into colums, in order to have 1 row per client?

      Example:
      Client A 1 2354
      Client A 2 4584
      Client A 3 10112
      Client B 1 1245
      Client B 2 3556
      Client B 3 2222
      ...

      And I would like to get to:
      Client A 1 2354...
      See more | Go to post
      No activity results to display
      Show More
      Working...