Hello,

I have a table that I record all doctor referrals each month. All dates are entered as the 1st of each month. EG the first week of October I entered all the referrals for September, and they were all given the referral date (RefDate) of 9/1/09.

I want to run a query that asks for all of the referrals from 9/1/08 and from 9/1/09. I can do this easily by changing the dates in the query each and every month, or with a parameter query. But I would like it to be more auomatic, like somehow using the Date()/DatePart or some other function. This way it will give my boss what he wants with no effort. He doesn't like exerting himself :).

Can anyone point me in the right direction?

Thanks,
Don

Aren't you going to need parameter input whatever you do, it is simpler from a form tho'.
You may want to look at Month and Year functions.

Brian