Add Previous record to Current record

B

broogle

Date Amount Cumm_Amount
01/01/06 1
12/01/05 2
24/01/04 3
24/01/06 4


The result I want:

-Sort by date and in cumm_amount
-first data in cumm_amount taken from first data in Amount field.
-Second, third, and so on taken from (Amount + Amount in next record)

Is it possible to create a query for this? Thanks


Result I expect:

Date Amount Cumm_Amount
24/01/04 3 3
12/01/05 2 5
01/01/06 1 3
24/01/06 4 5


Thanks
 
S

Sheila D

You will need to create a report and set the Running Sum property of the
amount field to Yes. However you may need to have something to identify which
records need to be added and then Group on that field (unless you already
have this) Access DOES NOT work like Excel so you cannot assume that records
are maintained tin the order in whihc they are entered.

HTH - Sheila
 
S

Sheila D

I'm sure you're right Jamie - bit of a sledgehammer to crack a nut though I
would have thought!
 
Top