title: Access Query Total Sum between Dates
body: <p>I'm looking a way to calculate the total quantity purchased between a specific dates and returns just one entry based on the item name. Here's the sample of my table and the result that I need:
  <a href="https://i.stack.imgur.com/QzPws.png" rel="nofollow noreferrer">Sample Table</a>
  <br/></p>
  
  <p>I'm not sure if Access have the capability to do this, I tried to use different formula and even grouping it together, but it didn't come out as what I need. 
  I did quite a bit of research as well, but none of them have the result I want. I really need to know the answer, it driving me nuts. Anyway, thank you beforehand for anyone that can help me.</p>