title: Microsoft Access - Generating a Specific Query
body: <p>Here's an interesting challenge that I'm facing. I dub you genius if you can create a query for this problem - It's been troubling me for quite some time. </p>
  
  <p>Here's two tables:</p>
  
  <p><strong>Customers Table</strong></p>
  
  <blockquote>
    <p>customerId, name</p>
  </blockquote>
  
  <p><strong>Transactions Table</strong></p>
  
  <blockquote>
    <p>transactionId, customerId, amountPaid, purchaseDate</p>
  </blockquote>
  
  <p>I want to select all of the customerId's for people who don't have any transactions for the current month, but owe from the previous months. </p>
  
  <p>For example, if the month I select is October, I want to select all of the customerId's where there are no transactions for October, but where the sum of transactions before October is greater than zero. Basically, my goal is to generate a report that displays  receipts for customers who owe nothing for the current month, but owe for previous months. Thanks for considering this problem. </p>