Results 1 to 3 of 3
  1. #1
    pbDudley is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2017
    Location
    New Orleans
    Posts
    39

    Combine records in field

    Hello
    I want to know how I can combine records from a table field into one new field
    So I have a unique id that sometimes is associated with the multiple records

    For example
    ID RECORD
    N-7777 X
    N-7777 C
    N-7777 B



    Is it possible to create a new calculated field in my query that would give me:
    ID RECORD
    N-7777 X, C, B

    I dont know the SQL command nor how to create it if its possible.
    Any help is much appreciative

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    ConcatRelated by Allen Browne

    http://allenbrowne.com/func-concat.html

  3. #3
    pbDudley is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2017
    Location
    New Orleans
    Posts
    39
    I saw that tutorial but access does not recognize the ConcatRelated command
    Im using MS Access 2010, is it a certain reference library that I need


    I see, I have to copy the code into a module first, then the ConcatRelated is available, let me see if I can get it to work

    thanks

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

Similar Threads

  1. Combine records into one row
    By Back2Basics in forum Queries
    Replies: 3
    Last Post: 03-10-2017, 03:36 AM
  2. Combine similar records
    By tareyj8569 in forum Access
    Replies: 7
    Last Post: 10-27-2016, 03:38 PM
  3. Replies: 1
    Last Post: 04-06-2016, 09:26 AM
  4. Replies: 3
    Last Post: 02-19-2013, 08:15 AM
  5. Combine Two Records into One from One Table
    By darcien in forum Queries
    Replies: 3
    Last Post: 10-10-2012, 09:17 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