Previous 12 months not corrent month.

[turks67 via AccessMonster.com]

I have a query with dates from the current month to the last 12 previous
months. How do I query the last 11 Months leaving out the current month?

Thanks

 

[Tom van Stiphout]

On Fri, 10 Jul 2009 03:10:39 GMT, "turks67 via AccessMonster.com"

I exclusively use DateAdd and DateDiff for date math:

.... where myDateField between DateAdd("m", -1,myDateField)
and DateAdd("m", -12,myDateField)
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP