a way to calculate a running total in SQL

[RBE]

Is it possible to calculate a running total in SQL, and if so how? Using access 2K.

 

[Cagliostro]

what do you mean running total? John Fill

ivfmd@mail.md

 

[RBE]

Kind of like this

order# order total Running Total
1234 2.00 2.00
1255 2.00 4.00
1268 2.00 6.00
1355 2.00 8.00

and so on.

I am trying to create this in a query so I can preform calculations off the field in other expression fields.

 

[Cagliostro]

if the table has some order column you can:

select [order], [order total],
(select sum(t.[order total])
from yourTable t where t.order < yourTable.order
) [Running Total]
from yourTable John Fill

ivfmd@mail.md