Results 1 to 2 of 2
  1. 02-29-2016, 11:49 AM #1
    scuba
    scuba is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    1

    Rearranging table format (from multiple to one row per rowID)

    Hi,



    I have a table with following kind of format:

    rowID color
    1 blue
    1 red
    2 red
    3 blue
    3 red
    3 green

    How can I transform it to following format:

    rowID blue red green
    1 1 1
    2 1
    3 1 1 1

    I am sorry if similar question has just been asked, but I couldn't find answer by searching.

    Thanks.
    Reply With Quote Reply With Quote
  2. 02-29-2016, 12:25 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Play with the crosstab query wizard.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Storing Multiple Days of the Week in a Yes/No Format
    By TheMachine in forum Database Design
    Replies: 2
    Last Post: 05-14-2013, 12:46 PM
  2. Table with multiple like fields that I need to display into an Array-like format
    By dmoro6 in forum Access
    Replies: 2
    Last Post: 01-08-2013, 04:59 PM
  3. Auto-rearranging columns
    By getoutside77 in forum Access
    Replies: 1
    Last Post: 05-10-2012, 01:45 PM
  4. Rearranging records on continuous form
    By aytee111 in forum Forms
    Replies: 6
    Last Post: 11-16-2011, 03:04 PM
  5. Datasheet as subform: retain or deny rearranging of columns.
    By Helen in forum Forms
    Replies: 8
    Last Post: 09-05-2011, 11:16 PM

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