closing and opening balence

[Guest]

i have two tables
table 1 bank transaction
field Deposit (currency)
" withdraw (currency)
" date (date)
table two expences
field item (text)
" expences (currency)
" date (date)
now how to take the Closing balence and opening balence for the year
that is closing balence of the previes year(1/1/01) to (31/12/01) is the
opening
balence for the year(1/1/02) to (31/12/02) & it contionues
cash in bank and plus as follows
FORMULA opening balence= previes year (sum( withdraw)-(sum(expences))
closing balence =( opening balence)+(presentyear(sum(withdraw) - _
present year(sum(expences))
and this chain will continue
how to do this please using query's
balu

 

[Guest]

Hi,

Select Sum(Withdraw) as SumWithdrawal from BankTrasaction, (Select
sum(Expences) from Expences where Year(Expences.date)=2006) as SumExpences
WHere Year(BankTransaction.Date)=2006

Regards,