Results 1 to 4 of 4
  1. #1
    Join Date
    May 2011
    Posts
    2

    Unanswered: kind of crosstab query

    Hi,

    I have a table in ms acces 2007 with

    field1 | field2
    Groente | Kool
    Fruit | Ananas
    Groente | Prei
    Fruit | Aardbei
    Fruit | Peer

    Now i want to create a table/quere that combines all values of field2 into 1 field for each value in filed 1

    like this

    field1 | field2
    Groente | Kool, Prei
    Fruit | Ananas, Aardbei, Peer

    Can someone help me out?

    Kind regards

    Koen

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6

  3. #3
    Join Date
    May 2011
    Posts
    2
    Hi Paul,

    That is what i was looking for.

    Thx a lot

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Happy to help, and welcome to the site!
    Paul

Posting Permissions

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