12 Month Rolling Income Query

[joelgiro]

Hi Everyone,



I'm trying to create a cross tab query that calculates the 12 month rolling income for several different product. I have the monthly income but I'm struggling to think of a way to continuously sum the last 12 months. (Jan to Dec, Feb to Jan, Mar To Feb etc) in access. I attached an excel example (Yellow Highlight) of essentially what I'd like. Hopefully this is possible. I appreciate your insights.

[ranman256]

I have a 'report' table. It has the 12 columns. (plus the Product)
you can either:
make a crosstab to append to this table
or
in a macro, run 12 append queries that post data to the report table 1 column at a time (for that time range)
then sum all columns in a final query to view the results

[June7]

Maybe this tutorial has solution for you http://www.fmsinc.com/MicrosoftAcces...ort/index.html

[joelgiro]

Thanks for the help. I'll let you know how it turns out.

[joelgiro]

Thanks for you help. I got what I needed!