Running sum

[tom]

How to do a running sum using Access?

 

[Ken Snell \(MVP\)]

Depends ... how do you want to use it, and in which object?

 

[tom]

I figured out how to use it in a report. Pretty easy actually,

How about in a query and a form?

 

[Ken Snell \(MVP\)]

For query, you'd need to do it in the query as a calculated field involving
either a subquery or another query.

For form, you'd need to do it in the RecordSource query as a calculated
field involving either a subquery or another query.


--

Ken Snell
<MS ACCESS MVP>