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
 
Ad

Advertisements


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

Top