Query criteria using dates (1 Viewer)

Toolman

Access Newbie
Local time
Today, 15:14
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
Local time
Today, 20:14
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