Running Totals in a Query

[SteveQL]

Hi All,
I need to see running totals in the output of a query. Something like this:

Item # Week Gross Ship Qty Rolling Gross Ship Qty
100 200401 100 100
100 200402 50 150
100 200403 100 250
101 200401 75 75
101 200402 10 85
101 200403 100 185


The data is is contained in one table. I tried to use the DSUM function, but did not get the resul;ts I expected.... there is the expression I used:
Rolling Gross Ship Qty: DSum[Gross Ship Qty],"TableName")

Is DSUM the appropriate function? What am I doing wrong??

Thanks for your help!

Cheers!
Steve

 

[Eupher]

SteveQL,

Take a look at faq701-5268 - it might get you started in the right direction.

Ken S.

 

[SteveQL]

Eupher,
That's exactly the kind of thing I was looking for... thanks!

 

[PHV]

Try this:
Rolling Gross Ship Qty: DSum([Gross Ship Qty],"TableName","[Item #]=" & [Item #] & " AND [Week]<=" & [Week])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244