Results 1 to 2 of 2
  1. 06-10-2015, 02:52 PM #1
    dollygg
    dollygg is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    73

    query

    TableA:



    Client Name Lawyer Name
    ClientA LawyerA
    ClientA LawyerB
    ClientA LawyerC
    ClientB LawyerA
    ClientB LawyerB
    ClientC LawyerA

    Result Wanted:

    ClientA LawyerA Lawyer B LawyerC
    ClientB LawyerA Lawyer B
    ClientC LawyerA



    OR

    Result Wanted:

    ClientA LawyerA;Lawyer B; LawyerC
    ClientB LawyerA; Lawyer B
    ClientC LawyerA
    Reply With Quote Reply With Quote
  2. 06-10-2015, 02:59 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    How about:

    http://allenbrowne.com/func-concat.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums