Balace

[chimworld]

Hello Friends,

I Have a Transaction table which content Date Debit Credit

i want to make query this Balance: [Credit]-[Debit] but in Carry Forward method

For example:
Debit Credit Balance
100 100
50 50
200 250
300 550

i found correctly in report but i want in to the Query of Form

please help in this matter...

I attached example file please download and Refer Report Menu

Thanks

 

[Uncle Gizmo]

I think you will find what you want here:
Rogers Access Library --- Excellent compendium of Access 2000 routines from Roger Carlson.

In this at example it's called a "running sum" I think that's what you're after.