Running Sum In Query

[Guest]

I hv this in my query

Cust Amt AccAmt
A 100 100
B 200 300
C 500 800

Ho to achieve AccAmt in my query column

TQ

 

[Pieter Wijnen]

SELECT A.Cust, A.Amt, (SELECT A2.Amt FROM MyTable A2 Where A2.Cust > A.Cust)
As AccAmt
FROM MyTable A
ORDER BY A.Cust

HTH

Pieter

 

['69 Camaro]

Hi.

I hv this
Ho to achieve AccAmt

C:

http://www.access.qbuilt.com/html/queries.html#RunningTotal

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.