W
Wahab
Hi
I have a TblTransctions table with TrnDate; CustID; CustName;
Description; Debit and Credit Fields.
With the help of DAO recordset I want to sort this table on CustomerID and
secondly by TrnDate. For every customer when month is finishing or changing
I want to take the total of Debit and subtract total of Credit and record the
result in another field which is Balance.
New month will start with inserting of 1 record which is “Balance B/F “in
Description field and Closing Balance in Balance field. Shortly I want to
create Ledger Book report from table.
Please guide me in this regard, or where I can get such type of reports any
sites pls. thanks in advance
I have a TblTransctions table with TrnDate; CustID; CustName;
Description; Debit and Credit Fields.
With the help of DAO recordset I want to sort this table on CustomerID and
secondly by TrnDate. For every customer when month is finishing or changing
I want to take the total of Debit and subtract total of Credit and record the
result in another field which is Balance.
New month will start with inserting of 1 record which is “Balance B/F “in
Description field and Closing Balance in Balance field. Shortly I want to
create Ledger Book report from table.
Please guide me in this regard, or where I can get such type of reports any
sites pls. thanks in advance