Running balance for debit and Credit using query in Access 2007

J

jk-can

Hello

Anyone can help me find out on how to create a running balance for Debit an
Credit using query in Access 2007. It's like thi
(Balance= Credit - Debit)

ID Dr Amount Cr Amount Balanc
1 0 1000 100
2 500 0 50
3 0 100 60

QUERY: DCP-Daily Cash Positio
FIELD: I
Dr Amoun
Cr Amoun

Please make the explanation/instruction simple for I am new in access

Hope to receive feedback as soon as possible

Thank you very much
JK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Balance (Debit and Credit) in Access 2007 3
ACCESS 2007 Running Balance in query 4
Running Sum in a query. 3
Debit and Credit transactions advice 2
Query is too complex for Access 2007 ? 2
Any Access SQL QUERY ? 1

Top