J
jez123456
Hi, I have a table with the following columns.
Credit Debit
£0.00
£400.00
-£20.00
-£20.00
£100.00
-£50.00
I need to create a query that will calculate a running balance like:
Credit Debit Balance
£0.00 £0.00
£400.00 £400.00
-£20.00 £380.00
-£20.00 £360.00
£100.00 £460.00
-£50.00 £410.00
Many thanks
Credit Debit
£0.00
£400.00
-£20.00
-£20.00
£100.00
-£50.00
I need to create a query that will calculate a running balance like:
Credit Debit Balance
£0.00 £0.00
£400.00 £400.00
-£20.00 £380.00
-£20.00 £360.00
£100.00 £460.00
-£50.00 £410.00
Many thanks