G
Green
In Access 2002, is there a way to create a 12 month rolling total for monthly
information. For example:
Month Monthly total 12-month sum
January 2004 5 5
February 2004 10 15
March 2004 15 30
April 2004 20 50
May 2004 5 55
June 2004 10 65
July 2004 15 80
August 2004 20 100
September 2004 0 100
October 2004 5 105
November 2004 10 115
December 2004 15 130
January 2005 20 145
February 2005 0 135
Any assistance on a rolling sum function based upon date would be
appreciated.
information. For example:
Month Monthly total 12-month sum
January 2004 5 5
February 2004 10 15
March 2004 15 30
April 2004 20 50
May 2004 5 55
June 2004 10 65
July 2004 15 80
August 2004 20 100
September 2004 0 100
October 2004 5 105
November 2004 10 115
December 2004 15 130
January 2005 20 145
February 2005 0 135
Any assistance on a rolling sum function based upon date would be
appreciated.