title: SQL Access, Sum one column's values only when ALL values in another column in are in specified range
body: <p>I have the following table (call it tblGifts) in an Access database (which is imported from an external source--and is frequently imported):</p>
  
  <pre><code>Person____GiftDate___GiftAmount  
   A________6/4/2014____$20  
   A________7/1/2014____$20  
   B________7/1/2014____$30  
   B________7/4/2014____$20  
  </code></pre>
  
  <p>There is a user form that prompts the user for a date range. My hope is that I can sum the GiftAmount column only when ALL of the GiftDates are in the date range provided. So, for example, if the user gives 6/30/2014 to 7/10/2014, the output will be something like: </p>
  
  <pre><code>Person____GiftAmount  
   B________$50  
  </code></pre>
  
  <p>Person A won't be included because he has a GiftDate outside of the range. </p>
  
  <p>I was thinking of doing something like the following: (This obviously won't work because it pulls person A as well)  </p>
  
  <pre><code>SELECT Person, Sum(GiftAmount)
  FROM tblGifts 
  WHERE GiftDate Between [Forms]![InputForm]![BeginDate] And [Forms]![InputForm]![EndDate]
  GROUP BY Person 
  </code></pre>