My boss wants to see how many dr referrals were made to Site A in Sept 09 and in Sept 08.  I could use a parameter query, but I would like it to be more "automatic".  Let me explain:
The first week of each month I enter all of the referrals for last month.  All of the referrals are given the referral ate of the first of the month.  I would like the query to "roll' with each month, possibly using the Date()/DatePart or other function.  This way when November rolls around the query will look for Oct 09 and Oct 08.
Sorry to be so long winded.
Thanks,
Don