In my Bank project, I had create two tables namely 1.Deposit 2.withdrawal. deposit with fields 1.accno 2.Date 3.Deposiamt and withdrawal with fields 1.accno 2.date 3.chequeno 4.Withdrawalamt.

I want to process transaction of particular Accno. so i had create transaction cursor with fields 1.Accno 2.Date 3.Chequeno 4.Depositamt 5.withdrawalamt 6.balance. In my transaction form i had put one command button namely "cmd transaction". In click event of transcation button i written code below

INSERT INTO TRANSACTION (DATE,DEPAMOUNT) SELECT DATE,DEPAMOUNT FROM DEPOSIT WHERE ACCNO=thisform.comboAccountNo.value AND DATE BETWEEN ctod(thisform.datefrom.value) AND ctod(thisform.datefrom.value)

INSERT INTO TRANSACTION (DATE,Withdrawalamt, chequeno) SELECT DATE,withdrawalamt,chequeno FROM WITHDRAWAL WHERE ACCNO=thisform.comboAccountNo.value AND DATE BETWEEN ctod(thisform.datefrom.value) AND ctod(thisform.datefrom.value)

the above code gives only transactions of particular accno between two dates without balance but I want to calculate balance amount also.

How to do this