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
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