Date field in query

[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

 

[Guest]

I there are better ways but this will do it.

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

 

[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