List records by Date - 'n' Months?

  • Thread starter Thread starter Kahuna
  • Start date Start date
K

Kahuna

Hi folks

I need to build a recordset where a date in the record is => 'n' months ago.

I guess its something like:

[months] = Forms!MonthsCombo
[Date] = rstSQL!Date
....
Where Now() - [Date] => [months]
....

Am I on the right track and how do I go about comparing the number of months
to a date?

TIA Cheers
 
Thanks Guys - sorted!

Used DateAdd to get FinalDate= [Date] + [Months]
Where FinalDate < Now()
This gave me the result I needed

Cheers
 
Back
Top