Rolling 24 Month History

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to calculate a rolling 24 month history based off of monthly data.
I have the data for the 24 months by part number, location and qty. I know
there's a way to do this automatically instead of taking the past 24 months
and then adding them up based off part/location.

What do I need to do to make this happen automatically? I'm guessing I
would need to write a loop. The only thing is that the 24 monthly buckets
would change each month so it wouldn't be a stagnant list.

Any help you could provide would be greatly appreciated. Thanks!
 
I'm trying to calculate a rolling 24 month history based off of monthly data.
I have the data for the 24 months by part number, location and qty. I know
there's a way to do this automatically instead of taking the past 24 months
and then adding them up based off part/location.

What do I need to do to make this happen automatically? I'm guessing I
would need to write a loop. The only thing is that the 24 monthly buckets
would change each month so it wouldn't be a stagnant list.

Any help you could provide would be greatly appreciated. Thanks!
Click to expand...

I suspect that a Totals query will work, without any loop - but since you
haven't posted any description of your table structure it's hard to say. How
are you recording the month - in a Date/Time field, or some other way? What is
it you're summing?

Please post the names of the relevant fields in your table.

John W. Vinson [MVP]
 
Back
Top