Running Sum-Desc Order

D

DD

Professionals,

I have a report for emissions. Each month we'll record the
# of gallons used for each of 20 or so products. Fields
are as follows in my table:

Field 1: Month/Year
Field 2: Product (look up to the product table)
Field 2: Gallons Used (for this month)
Field 3: Emission Value (for this month) (this changes
from month to month and therefore this value is in the
products used table as opposed to the products table.

In my report I have the following in a date header field
and it is sorted by newest date at the top of the report
(date descending):

Date:(July 2004)
Total Gallons:(Sum of gallons of all products used)
Total Emissions: (Sum of Gallons * Emissions)

I need two additional fields on this report and then I
need these totals in a different than normal order:

I need a running sum of the total emissions for each
calendar year. And the running Total should look like the
last column shown below and it needs to be in descending
order.

Emissions Running Total Emissions
(Calendar Year)

July 2004 1 17
June 2004 2 16
May 2004 4 14
April 2004 1 10
March 2004 3 9
February 2004 5 6
January 2004 1 1

Then, I need to in another column to the right of running
total for calendar year, I need to calculate the running
total for the 11 months preceeding. So for example next to
May 2004, the running total will consist of from June 2003
through May 2004.

Thanks in advance. It is very confusing to describe this
and I hope it is clear.
 
Top