title: Creating a frequency table in Access VBA
body: <p>I have a table where different participants are given multiple boxes of medicines on multiple days. I am trying to create a frequency table showing how much medicines have been distributed by the number of boxes to the participants.<br>
  <img src="https://i.stack.imgur.com/0EAOf.gif" alt="enter image description here"></p>
  
  <p>The result I'm looking for is -</p>
  
  <p>2 boxes = 1 (since only Lynda got a total of 2 boxes), 4 boxes = 2 (since Ryan and Rinky both got a total of 4 boxes after adding up the medicine boxes)</p>
  
  <p>Please let me know what approach would be the best in this case.
  Thanks for your help.<br>
  -Nams</p>