Friends,
I am developing a database for accounting software. I have one problem
regarding calculation of balances on daily basis for all ledgers. I am using
Access 2003 as frontend. While designing I found that maintaining of daily
balances is impossible to client's requirements. But as the solution I to
execute two SQL queries for 365 times to calculate Opening and closing
balances. what i need is a hint/example to write a function/SQL statement to
run these queries in single/minimum iterations.
table format:

LedgerID | Opening Credit | Opening Debit | Current Credit | Current Debit |
Closing Credit | Closing Debit | Date

Previous dates closing balance should be the opening for next date.

Please suggest the answer.
Thanks,
CPK

Reply via email to