Hi Guys
I have a report 2002 which has a Running Sum Caluclation for each month January to December.
So February(RunningSum) = January minus February. and so on for March. etc etc
This all works well, untill I get to January 2003 which is a new report, based on a new query, but I need the 2002 December Running Sum Value to caculate the January 2003 Running Sum value, help.
How do I grab the Running Sum value of December 2002 to put in January 2003.?
It is doing my head in.
I hope this is clear enough
Thanks
H
I have a report 2002 which has a Running Sum Caluclation for each month January to December.
So February(RunningSum) = January minus February. and so on for March. etc etc
This all works well, untill I get to January 2003 which is a new report, based on a new query, but I need the 2002 December Running Sum Value to caculate the January 2003 Running Sum value, help.
How do I grab the Running Sum value of December 2002 to put in January 2003.?
It is doing my head in.
I hope this is clear enough
Thanks
H