Summing up numbers from diffrent colums

[littlesunshine]

Hi guys,

I need your help summing up numbers from different colums.



I have this:
Start_Date End_Date y1 y2 y3 y4 y5
A 1/1/2003 1/1/2008 #s #s #s #s #s
B 1/1/2004 1/1/2009 #s #s #s #s #s
C 1/1/2005 1/1/2010 #s #s #s #s #s
D 1/1/2006 1/1/2011 #s #s #s #s #s

How can I do this:
2003 = Ay1
2004 = Ay2+By1
2005 = Ay3+By2+Cy1
2006 = Ay4+By3+Cy2+Dy1
2007 = Ay5+By4+Cy3+Dy2
2008 = By5+Cy4+Dy3
2009 = Cy5+Dy4
2010 = Dy5

TOTAL
Sum1= Ay1
Sum2= Ay2+By1
Sum3= Ay3+By2+Cy1
Sum4= Ay4+By3+Cy2+Dy1
Sum5= Ay5+By4+Cy3+Dy2
Sum6= By5+Cy4+Dy3
Sum7= Cy5+Dy4
Sum8=Dy5

I need to know the total amount per each year. Is this possible?

Thank you very much.

[ConneXionLost]

Deleted duplicate

[ConneXionLost]

You should normalize your table like this:

Type	Period	Amount

A	2003	#s
A	2004	#s
A	2005	#s
A	2006	#s
A	2007	#s
B	2004	#s
B	2005	#s
B	2006	#s
. . .

Once done, a simple sum query would provide your answer.

Cheers,