Year to DATE by Month

[lugnutmonkey]

I am trying to set up a query that looks back 24 months from the current and/or selected month and measures the % change. this query would in effect give me a month over month comparison going back one full year. I have tried using a select query where the months are in between Month(Date)) and Month(Date))-24. Thisquery only reurns the current month going back 24 months.



So that if the current month is january 2013 it will only select january 2013, januray2012 and january 2011. I would like it to select all months between the latest and earliest date.

If you have any questions or would like to see the code that i am using just let me know an I will happily post it.

[June7]

Try:

BETWEEN Format(Date,"mmyyyy") AND Format(DateAdd("m",-24,Date),"mmyyyy")