Grouping info for the last twelve months

[herbc0704]

I have a query that gathers sales data based on the invoice date of sales. I need to create a prompt that sums sales for the last tweleve months. The problem I am having is when sales fall in the prior year. I am sure there is an easy way to get this.

[Robeen]

Try this:
>= DateAdd("yyyy", -1, Date())

Let me know if it works!

[herbc0704]

Try this:
>= DateAdd("yyyy", -1, Date())

Let me know if it works!

Thanks it does what I need it to!