okay i will tell u exactly what i want..which bit complex
u have 2 tables transacion and balance
transaction for everyday activity and balace is recorded at the end of day.
transaction table : we have date ,balance id,cresdits,debits and net
balance table we have : balance id,balance amount
transaction table is
ID Date Netbalance
1 12 apr 50
1 13apr 89
1 16apr 56
1 17apr 78
2 18apr 90
1 19APR 98
2 20apr 89
balance table has one record for each balacne id.it always hold currenct balance
my req is to show total balance for all dates.if there is no transaction then i need to find what is he possible balance for that particular day.
now question is how will i find balance on that day?
i need to collect balance amt frombalance table that would be for currenct day and subtract with net balance to obtain my balnce on previous day.
Ex: balance credits debits net
if i have credited 100 on 12 th apr then,
100 100 - 100
if credited 200,13apr
300 200 - 200
if debited 100,15 apr
Bal cre deb net
200 - 100 -100
but in actual table balance value willl be over ridden
we have only 200in balance and there is no date field
if i want to knw what was the balnce on 14 apr
then i need to take balance amount from balance table that would be for currenc date say 18th apr
200 in example
subtract that witrh 18th apr net..as we dnt have record it should be 0 for 18th
so balance on 18 is 200-0=200
then on 17th,200-0=200
on 16th 200-0=200
on 15th 200-(-100)=300
on 14th its 300-0=300 so we go the balance on 14 th apr.
This is what i wanted.Hope its clear.
Can u help me further on this
Thank you
Regards,
Prajna
