Results 1 to 2 of 2
  1. #1
    Bing is offline Novice
    Windows 98/ME Access 2007
    Join Date
    Jun 2011
    Posts
    1

    Combining rows

    I have a table with duplicates. I would like it to remove all but one instance of each number, and show me a concatenated version of the other column. Here is an example of what I'm trying to accomplish:

    111 John
    111 Harry


    111 Steve
    222 John
    222 Steve
    333 John

    I would like the result to look like this:

    111 John, Harry, Steve
    222 John, Steve
    333 John

    Seems easy, but I can't seem to come up with anything. Thank you so much for any help!!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Combining value in multiple rows into new field
    By stricklanpbs in forum Access
    Replies: 4
    Last Post: 05-05-2011, 11:29 AM
  2. Combining queries
    By wildlifeaccess in forum Queries
    Replies: 10
    Last Post: 09-20-2010, 07:35 AM
  3. combining 2 tables
    By psrs0810 in forum Access
    Replies: 11
    Last Post: 01-07-2010, 08:55 AM
  4. Combining columns into rows
    By steeveepee33 in forum Queries
    Replies: 5
    Last Post: 04-30-2009, 09:18 PM
  5. Help combining 3 tables
    By luscioussarita in forum Queries
    Replies: 1
    Last Post: 12-14-2005, 03:22 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
  •  
Other Forums: Microsoft Office Forums