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
