Find records from past month, the current month or the next month 1

[LD1010]

Thanks for reading my post.

I can't seem to wrap my mind around how to do this. I'm trying to return all the records from tblServiceDates where the service date occurs in either the past month, the current month or the next month.

Let's say the table contains the following dates:

11/5/2010
12/10/2010
1/3/2011
2/21/2011
12/15/2011

Based on todays date of 1/24/2011 I need the following dates returned: 12/10/2010, 1/3/2011 and 2/21/2011

Any help in how to approach this would be much appreciated.

 

[dhookom]

Try:

Between DateSerial(Year(Date()), Month(Date())-1,1) and DateSerial(Year(Date()), Month(Date())+2,0)

Duane
Hook'D on Access
MS Access MVP

 

[LD1010]

Thanks again Duane, that's just what I needed.

I'm very thankful for your willingness to share your wealth of knowledge.