Access Running Totals for previous 12 months

[Apple08]

Hi everyone

Please could anyone advise how to set up Access formula (in query may be?)for previous 12 months running total?

A new record will be added each month. After the new record 31/10/2015 is added, then the running total only sums up from 30/11/14 to 31/10/15. If new record 30/11/2015 is added, then the running total only sums up from 31/12/14 to 30/11/15.

Your help is appreciated. Thanks very much.

 

[alansidman]

This thread may be helpful

http://www.mrexcel.com/forum/micros...calculation-based-fields-several-records.html