nesrina

good evening Mr. Abo Hady I try to design database for company working in the exchange market and i have table for accounting transaction including the following fields 1-incoming balance 2-fees 3-bank interest 4-ending balance and the ending balance =incoming balance+bank interest - fees my proplem here how to tell access to transfer the ending balance for transaction No1 as incoming balance for transaction No 2 ,,,and keep on for all transaction i ll appreciate your cocerning , thanks in advance

Hello everyone, i am working in Access database & i need help in the transaction table to transfer the ending balance for transaction No1 as a begining balance for transacion No two?