title: How to combine text values from multiple rows into a single cell in Access query
body: <p>I have a table for added discount or motivation for employee salaries each month in the year. This table contains a field that can contain only the words "Discount" or "Motivation" using lookup.</p>
  
  <p>Every month I can add more than one discount or motivation, so when I want to pay the salaries in the end of the month, I want these data grouped in one row for each employee.</p>
  
  <p>This is the table that takes the discount and motivation during the month. The table name is Table1:
  <a href="https://i.stack.imgur.com/yp8El.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yp8El.png" alt="enter image description here"></a></p>
  
  <p>The desired query result:
  <a href="https://i.stack.imgur.com/lRpTI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lRpTI.png" alt="enter image description here"></a></p>