Running Sum again!!

[astrevens]

Ok here is what ive got:
tblReports:
Account Date Cost Value Target
ashur001 01/10/01 £100 £20 £200

as an example.

what i need to do is select a date range then have a running total/sum on the cost,value and target for each account in that date range. Can anyone help? i have tried the Dsum that was posted here before but failed to get it working.

 

[Zelandakh]

Are you looking for a graph, a report, a query or what?

 

[astrevens]

im looking to do several graphs off of it. so i was thinking of doing a make table query to give me the info.
Then i need to do a line chart for each of our sales reps (01,02,03,04) which has the total cost,value aginst the target for the month.