Running totals within a field

[JoeyB_99]

I am using Access 2007.

I would like help creating a query (queries?) that would give me cummulative/running totals for each cost code. Here is some sample data,


Cost Code A; October 10/12; 100.0
Cost Code A; October 17/12; 87.0
Cost Code A; October 24/12; 55.0
Cost Code B; October 17/12; 1.0
Cost Code B; October 24/12; 3.0


I would like the finished product to look like

Cost Code A; October 10/12; 100.0
Cost Code A; October 17/12; 187.0
Cost Code A; October 24/12; 242.0
Cost Code B; October 17/12; 1.0
Cost Code B; October 24/12; 4.0

I receive the data in discrete quantites based on different dates. So, I would like out put that keeps/shows the cost code and date but the quantity is a running total.

Any help would be greatly appreciated.

I have read MS article 290136 and it does not quite help me out...unless I'm not understanding something.

 

[jdraw]

I suggest you start with googling "ms access running sums".
There are lots of hits and some may get you closer to solution.

MS article 290136 gives step by step instructions with example for running sum in a query.