Query criteria using dates (1 Viewer)

Toolman

Access Newbie
Joined
Jul 25, 2009
Messages
28
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
 

Brianwarnock

Retired
Joined
Jun 2, 2003
Messages
12,701
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
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom