Return records 2 months out

[Guest]

Hello. I have a table with insurance policy information and need to get
policies with an Effective Date within the next two months of running the
query. So, if I run the query any time in August, I would need the query to
return all policies effective any time in September or October.

Any help is very appreciated. Thanks!

 

[fredg]

Hello. I have a table with insurance policy information and need to get
policies with an Effective Date within the next two months of running the
query. So, if I run the query any time in August, I would need the query to
return all policies effective any time in September or October.

Any help is very appreciated. Thanks!

As criteria on the EffectiveDate field:

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