Help - This Is Doing My Head In

[Hiten]

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

 

[Hiten]

Thank you mate, works like a dream

 

[Rich]

Mate's actually a Sheila

 

[Hiten]

D'oh

 

[Hiten]

LOL

 

[Hiten]

hI pAT

Can i ask another question

In a report I have all years across the detail line. And All the Month as a header

If I want to monus one year from the other how do I do it

e.g
January
2003 $ 10

2004 $ 25

so $10 - $25

as i am not to sure if you can refer to the detail line above in a report calculations

H