Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement