Results 1 to 2 of 2

Thread: Group by

  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Angry Unanswered: Group by

    I have a table:
    id Name grp
    12 sjoo 123
    13 sjoo 456
    14 sjoo 890
    15 abcd 123
    16 abcd 456
    17 abcd 890

    I need to create the following output:
    id Name groups
    12 sjoo 123,456,890
    15 abcd 123,456,890

    is there a sql command that can do this in MS Access.

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    If you do not need the 12 and the 15 to show up, a pivot query will do.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •