calculating dates

[inneedofhelp]

I would like a query only to show records within the last 12 months. However, i would like all the records for each of the months. Please help..

 

[Mile-O]

Build a query as usual that picks the last twelve months. Post back if you need more detail on this.

Then, for getting individual month details you can use the DCount - or more necessary domain aggregate function - using the month number (1 = Jan, ...12 = Dec) as a criteria.