I Need SQL Query Statment For Showing Balance Sheet
Posted on 2003-11-05
I have a MS Access Table AccountsDetail having following fields
AccountNo AccName Group Parent Type Debit Amount
1 Assets Asset General
101 CurrentAssets Asset 1 General
10101 Cash Asset 101 Detail 10000
2 Liabilities Liability General
201 Payable Liability 2 General
20101 Farhan Liability 201 Detail -10000
I Need a SQL Query Statment, that could show a Balance sheet where only "General" Type Accounts must appear, carrying the Total Debit amount of thier child accounts which can be Further General or Detail Accounts.
Thanx in Advance.