Day balances problems
Happy new year to all
help required on access vba reports
i created access database for my establishmnet.
contaning query DATA.
which as following fields, with data as shown (table to as same fields)
DATE VOUCHERNO CREDIT DEBIT
12/03/2006 3 10
12/03/2006 4 20
12/03/2006 5 40
12/04/2006 6 15
12/04/2006 7 30
12/04/2006 8 50
basing on this query, report should be generated showing Opening and closing balances day wise as shown below
Report
DATE VOUCHERNO CREDIT DEBIT
12/03/2006 OB 50 ------------------> previous day
12/03/2006 3 10 CB
12/03/2006 4 20
12/03/2006 5 40
CB 40
--------------------------
Day Grp fotter 80 80
12/04/2006 OB 40
12/04/2006 6 15
12/04/2006 7 30
12/04/2006 8 50
12/04/2006 CB 35
---------------------------
Day Grp 85 85
it runs for the whole month
OB, CB is not entered in table, it should be generated at runtime
OB should be carried forward from previous day CB
OB, CB should be generated while report is been previewed
Experts help is required in this
Thanking all in advance
civa
|
