Ok, so here is the issue. I have two tables, BillingPeriods and Receipts.
My billingperiod table has several dates that I want to represent as A cutoff date of my billing period. What I want is to have the query show only Reciept of Payments that have occured from the current Date to the day after the last cut off date in order to pull the current reciepts for the bill month.
I will post some of the table data to help a little more.
Table: BillingPeriods
CutOffDate
1/15/2009
2/26/2009
4/9/2009
5/14/2009
7/2/2009
8/13/2009
9/24/2009
11/5/2009
Table: Receipts
RecieptBy(column 1)
Bill
Bill
Joe
Bill
Ryan
Doug
Mike
Joe
Bill
Adam
RecieptDate(column2):
06/20/2009
06/23/2009
06/26/2009
07/22/2009
07/20/2009
07/21/2009
07/23/2009
07/24/2009
07/25/2009
07/26/2009
So the query build would include reciepts from 7/3/2009 to today, 7/27/2009.
I want it to be auto-updateable for next month. so that as soon as 8/14/2009 comes the query will be blank until reciepts start being entered.
I hope there is an answer to this problem. Thank you for the help in advance.