How to set Cumulative Sum

[auschick]

I think that was the word for it.

The thing I'm making is something like this.

and so on....

I'm not sure how to make the total of my 'ideal report' to go up and down, as I add the figures. I have made the list of already in Access, but I have been trying to make the total work out but all I keep getting is 'Error'.

Is there any way to do this? Thanks.

 

[Jman883]

You need to put a text box below the report footer and then make the expression in the control source
=Sum([debit])
this will sum your field for debit. if you what to sum across as I see in your totals then try putting the expression in the details section like =Sum([debit)

 

[Rich]

Use the running sum property of an unbound textbox

 

[auschick]

I see what your trying to say, however I've been trying that but its not working for me. I guess I'm not doing it right!

 

[Rich]

It's just [Credit]-[Debit], though it doesn't look like you have an opening balance as yet

 

[auschick]

I got it! Thanks everyone! I realized my mistake. I wrote $1000 as '1 000' , and thats why the error came.

Thanks again!