Solved Row wise sum

[mfaisal.ce]

Dear,
I have a table

but i need to see the result like this,

any one can guide me , how i can do that...... means i need to add the previous row to current row.....

regards,

 

[theDBguy]

Hi. Do a search on Running Sum queries. There's plenty of examples for it. Sorry can't give you one right now.

Sent from phone...

 

[Uncle Gizmo]

I agree, running sum and a good example from Roger is here:-

How do I create a Running Sum Query?

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

 

[isladogs]

Unless you need this in a query, the easiest way is to use a report. Set the Mark field property to Running Sum = Over All.
See attached

 

[mfaisal.ce]

Unless you need this in a query, the easiest way is to use a report. Set the Mark field property to Running Sum = Over All.
See attached

thanks bro, its really easy & simple....