Date field in query

K

klr

I need to add criteria to pull through all records where visit date is
current month and next 2 months (i.e. 01.09.06 to 30.11.06). Can
anyone advise what I should do?

Many thanks

KLR
 
K

KARL DEWEY

I there are better ways but this will do it.

Between Date()-Day(Date())+1 and DateAdd("m",3,Date()-Day(Date())+1)-1
 
J

Jeff Boyce

In design mode of the query, in the Selection Criterion "cell" under the
field [VisitDate], you'd use something like (your syntax may vary):

Between DateSerial(Year(Date()),Month(Date()),1) And
DateSerial(Year(Date()), Month(Date()+3,0)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top