title: Access Concatenate rows into single rows: extra conditions needed
body: <p>I'm working with an Access database and I need to concatenate different related rows into 1 row. I found a solution <a href="https://stackoverflow.com/questions/230241/does-ms-access2003-have-anything-comparable-to-stored-procedure-i-want-to-run">here</a> and used it with great success. However I need to add extra conditions to it, it should only be done if certain other columns are equal too.
  For example:</p>
  
  <p>1 X Alpha</p>
  
  <p>2 Y Beta</p>
  
  <p>1 X Gamma</p>
  
  <p>1 Z Delta</p>
  
  <p>should become</p>
  
  <p>1 X Alpha,Gamma</p>
  
  <p>1 Z Delta</p>
  
  <p>2 Y Beta</p>
  
  <p>Does anyone know to do this, especially for a newbie like me?</p>