Results 1 to 2 of 2
  1. #1
    Rriemer is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Oct 2015
    Posts
    7

    Combining field info

    I have a table that lists every event a customer has attended. Unfortunately there is a record for each event a contact went to. I want to create one record for each contact and in a new field put all the events they went to, separated by a comma. Below is the table... Field three is the event. The Hidden VIS field is the contact.. I want to see this as one record for contact 1040040 went to Winter Connections Brunch..., 2017 Winter Connection...,PB Temple Emanu-El... etc... Placing the event name in a new field called Events Attended
    PG_Score Id cv__Event__r#Name Account__r#Id Account__r#VIS_Number__c cv__Contact__r#Id cv__Contact__r#Hidden_VIS__c CRMfusion__Index CRMfusion__Limit CRMfusion__MarkForDeletion CRMfusion__SelectionSet EVENT_ATTENDEE EVENT_INVITEE
    0 a0Md000000fARd2EAG Winter Connections Brunch 2/25/16 421P 001d000000Hule4AAB 1040040 003d000000Rf6y9AAB 1040040 2895 No False -1 ATTENDEE
    0 a0Md000000kgGHJEA2 2017 Winter Connection Brunch 2/2/17 434H 001d000000Hule4AAB 1040040 003d000000Rf6y9AAB 1040040 74 No False -1 ATTENDEE
    0 a0Md000000fA1SfEAK PB Temple Emanu-El Breakfast w/ Hal Linden 1/10/16 423X 001d000000Hule4AAB 1040040 003d000000Rf6y9AAB 1040040 2282 No False -1 ATTENDEE
    0 a0Md000000wKsjpEAC PB Wycliffe Parlor Meeting 3/16/17 446G 001d000000Hule4AAB 1040040 003d000000Rf6y9AAB 1040040 2529 No False -1 ATTENDEE
    0 a0Md000000kghZYEAY PB Shabbat Temple Emanu-El 1/29/17 438W 001d000000Hule4AAB 1040040 003d000000Rf6y9AAB 1040040 1864 No False -1 ATTENDEE


  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,521
    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 values in the same field
    By Sidran in forum Access
    Replies: 4
    Last Post: 07-31-2014, 11:10 PM
  2. Replies: 14
    Last Post: 07-22-2013, 12:39 PM
  3. Replies: 1
    Last Post: 08-12-2011, 12:46 AM
  4. Replies: 4
    Last Post: 02-08-2011, 08:43 AM
  5. combining field from two records into one
    By RedGoneWILD in forum Queries
    Replies: 8
    Last Post: 07-13-2010, 09:47 AM

Tags for this Thread

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