Results 1 to 6 of 6
  1. #1
    caniread is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2015
    Posts
    86

    Bring together values separated by comas


    Is there any way to combine all the text in a column separated by commas?

    Thank you for your help.

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,740
    Having a hard time visualizing what you want. Can you explain in more detail?

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

  4. #4
    caniread is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2015
    Posts
    86
    Yes, trying to find other ways to get to my desired end result.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Short answer to short question, review http://allenbrowne.com/func-concat.html.

    Whether or not that will actually serve your needs is not known.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    June has offered the same answer I was going to give, and that may be what you should research.
    But you'll note the comment from Davegri====hard time understanding what you want.

    Sounds familiar, right.
    Take the time, even post a mock up example of your starting data and the output you want.
    We'll sort it out, but only you knows what you want. I understand the difficulty in putting that in to words, but it has to be done otherwise we are just guessing. And that is often a long way to an answer.

    As I said in other post, revise what I scribbled to make something meaningful along the lines of --I need this...
    Good luck.

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

Similar Threads

  1. Replies: 4
    Last Post: 06-26-2018, 02:02 AM
  2. Exporting data to Ms Excel Comma Separated Values
    By deepakg27 in forum Import/Export Data
    Replies: 20
    Last Post: 01-22-2018, 12:15 AM
  3. Form combobox won't bring up values
    By sevanty7 in forum Access
    Replies: 7
    Last Post: 05-17-2013, 11:45 AM
  4. Replies: 1
    Last Post: 07-26-2012, 10:20 AM
  5. Replies: 7
    Last Post: 05-16-2009, 08:08 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