title: Microsoft Access query combine multiple records by ID
body: <p>I am using Access 2007 on windows 7 Enterprise
  I apologize if this has been covered, but I couldn't find it.
  In a table where i have:</p>
  
  <p>ID.....info....   place....   because</p>
  
  <p>1.....      abc ...   home.....    fridge</p>
  
  <p>1 ....     abc ...   work.......    desk</p>
  
  <p>1.....      abc....    play.......    pockets</p>
  
  <p>I would like a query that the result is</p>
  
  <p>Id.. info....as1 ....    as1......    as2.....    as2 ....   as3  ... as3</p>
  
  <p>1....abc...home...fridge...  work...  desk...   play..   pockets</p>
  
  <p>the number of results by ID may vary, and the "Place and because" may not be the same.</p>
  
  <p>any help is greatly appreciated
  Thanks in advance</p>