title: MS Access report grouping
body: <p>I am trying to automate a time-consuming admin function that has to happen weekly, but I can't seem to get it right.</p>
  
  <p>I am including an excerpt from our weekly non-conformance report, which I have been preparing in Word for months
  <img src="https://i.stack.imgur.com/5bcf7.jpg" alt="MS Word report"></p>
  
  <p>However, it would be much quicker if this report could be generated straight from the MS Access database.</p>
  
  <p>Everything looks OK if there is only one "corrective" and one "preventative" for each non-conformance. But when multiple actions are generated by a non-conformance, I just can't get the "correctives" to stay together, but separate from the "preventatives" which should also stay together. Here are the exact same non-conformances in my latest attempt at a MS Access report:</p>
  
  <p><img src="https://i.stack.imgur.com/UFZuy.jpg" alt="MS Access report"> </p>
  
  <p>For RN.JS-4920, the singular "preventative" is repeated for each unique "corrective". For RN.JS-4919 the singular "corrective" is repeated for every unique "preventative".</p>
  
  <p>How do I change the grouping to keep the "correctives tabulated together, and the "preventatives" tabulated together?</p>
  
  <p>Thank you in advance</p>