Get Begin Balance

[eris]

For all Members...i'm a newbie please help me
I try to bulid a General Ledger software using VB 6 n CR 8.5
i found a problem to get Begin balance for My report...
the report display begin balance,today transaction(change) n Final Balance

The report fornat like this..

begin balance 8000

Transaction1 2000
Transaction2 1000
Transaction3 -500

Final balance 10500


i have 2 table

1.Transaction

tracId date accNo Note debet credit
1 30/11/2006 1 pay 500 0
2 30/11/2006 2 xx 100 0
3 31/11/2006 1 yy 300 0
4 31/11/2006 2 zz 0 150

2.Daily Balance

accNo date change Final_balance
1 29/10/2006 100 4500 <--being begin balance in 31/10
2 29/10/2006 200 4900
1 30/10/2006 500 5000
2 30/10/2006 100 5000


For example : today is 31/10/2006
i want to create a report,to show today's transaction n i using selection expert

transaction.date=currentDate

now i can't show the begin balance because i can't access final_balance (date 30/11/2006). my problem is i can get the value one day before for the begin balance...
does anyone know,how to solve my problem?
or Any idea?

sorry if my english is too bad...