Querying between two dates for one record in the previous month.

[justauser]

I am trying to query records that occurred in the previous month that also falls within a range of dates. I was pulling records that occurred in the previous month but I think I'm missing records. I was wondering if I can write and expression that will pull only in the previous month and that date occurred within the two dates. For example, if the start date is 01/31/2012 and the end date is 02/01/2012, it would pull that record because it was being processed during the previous month. I have tried to write the expression like this, but not having much success.

Month(Between[Table]![Date1]and[Table]![Date2])

[pbaldy]

Does this help?

http://www.baldyweb.com/OverLap.htm