Results 1 to 3 of 3
  1. #1
    Eddy Sincere is offline Competent Performer
    Windows 10 Access 2013
    Join Date
    Jul 2014
    Location
    Carson City, NV
    Posts
    114

    Display query results separated by commas after concatenation

    I have a query which concatenates three fields into a single result. Here's query field expression: E1: [C1] & " " & [C2] & " " & [C3]

    C1 C2 C3
    F1 - Swen Jill Tommy
    F2 - Robert Jenny Bill
    F3 - Gant Kelly Andy

    Query Result
    F1 - Swen Jill Tommy


    F2 - Robert Jenny Bill
    F3 - Gant Kelly Andy


    My problem is I need to perform one more concatenation so that the query results to be listed on the same line separated by commas like the example below.

    Example

    Swen Jill Tommy, Robert Jenny Bill, Gant Kelly Andy

    Thoughts?

  2. #2
    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,716
    Allen Browne's concat related
    would be a good starting position. Test, adapt
    Good luck

  3. #3
    Eddy Sincere is offline Competent Performer
    Windows 10 Access 2013
    Join Date
    Jul 2014
    Location
    Carson City, NV
    Posts
    114
    Crud. I was hoping for simpler solution. Like using a second query to concatenate the results of the first. I'll jump into the Allen Browne site and see what it offers. Thanks.

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

Similar Threads

  1. Replies: 4
    Last Post: 06-25-2015, 01:35 PM
  2. Replies: 6
    Last Post: 05-19-2015, 09:34 AM
  3. Replies: 10
    Last Post: 11-18-2014, 04:25 PM
  4. Replies: 3
    Last Post: 05-02-2013, 10:36 AM
  5. Replies: 10
    Last Post: 04-17-2013, 04:15 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