Sum Query

[behrad]

I have this Table/Query :

Item-----number
a----------1
b----------3
c----------6
d----------7

How I can make the following query?

Item-----number-----sum
a----------1 ---------1
b----------3----------4(1+3)
c----------6----------10(1+3+6)
d----------7----------17(1+3+6+7)

 

[MStef]

Look at "DemoSumQA2000.mdb" (attachment).
Look at Table1, Query1, Module1, Form1.
Open form and try.

 

[behrad]

Many Thanks.

Many Thanks.