You can also do it as you were, just do not filter your data only on last full month but rather make it the largest scope you need, something like...
table.date in date(year(currentdate),10,1) to currentdate
or
table.date in date(year(currentdate)-1,10,1) to dateadd("yyyy",-1,currentdate)
Edited by DBlank - 22 Aug 2011 at 4:37am