Results 1 to 4 of 4
  1. #1
    accessmatt is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    199

    Help with a concatenate statement in a Group By Query


    Hello,

    Can anyone help me get this result from the attached table? It's basically a Group by (User) but I'm struggling to figure out how to combine the responses (seperated by a comma)

    User Combined Response
    a1234 abc,def,ghj
    b4321 qwrt,tyui,opasdf,hjklm,mnbvc,awes,uty

    Thanks!

    example.accdb

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,791
    How odd it is that this is about the 3rd request for this sort of thing in the past few days. Almost makes one think it is a course assignment problem.
    Perhaps this will work for you?
    http://allenbrowne.com/func-concat.html
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    accessmatt is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    199
    thanks @Micron, that worked perfectly but this, at least mine, isn't part of a course assigment.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,791
    Glad to know that worked for you.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. GROUP BY and Concatenate?
    By SIMMS7400 in forum Access
    Replies: 6
    Last Post: 03-14-2021, 03:49 AM
  2. concatenate value in rst statement
    By chromachem in forum Programming
    Replies: 1
    Last Post: 05-03-2016, 11:05 AM
  3. Replies: 4
    Last Post: 03-04-2016, 10:08 AM
  4. Replies: 7
    Last Post: 12-22-2012, 06:31 PM
  5. GROUP BY sql Statement
    By rlsublime in forum Access
    Replies: 1
    Last Post: 07-13-2012, 09:21 AM

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