Running Totals

[Guest_imported]

Can anyone tell me how to create a running total in a view.

Example
Item Qty Running Total
Part1 20 20
Part2 30 50
part3 10 60

Thank You

 

[Cagliostro]

I belie a good idea is you to add an index(as RecordID) at the first:

RecordID Item Qty Running Total
1 Part1 20 20
2 Part2 30 50
3 Part3 10 60

at the second:
----
select
Item, Total,
(
select sum(qty) from YourTable t
where RecordID <= YourTable.RecordID
)RunningTotal
from YourTable
order by RecordID
---- John Fill
ivfmd@mail.md

 

[Andel]

SELECT Item, Qty, (select sum(qty) from yourtable T
where T.Item <= yourtable.Item) 'Running Total'
FROM yourtable
ORDER BY Item
Andel
andelbarroga@hotmail.com

http://andyb.8m.com