Rolling 12 or 6 Month Query

[Shakenaw]

I have a date field "yyyy/mm/dd"

the data is back up til 2009, but i only want to bring a rolling 12 months of data.

What should my query look like in Access

I did


Month()-12

This gives me an error Message


Please Help

[rpeare]

if you're looking for the last 12 months as of the current date it would be

between dateadd("y", -1, date()) and date()

[Shakenaw]

Thanks I'll try that