i have a db whic permit to Admit students, receive fee (advance or tatal fee). Each student has a contract value which is stored in the table "Contract". this table comprises: ContractID, ContractValue and StudentID.
the amount that is paid by a student is stored in the table "Finace". Knowing that a student in a bit to complete the contract value can pay many times, i have a problem calculaing the balance automatically using Access.
So i want to be able to calculate the balance of student fee based on the contract value and the amount the sudent has already paid. Is this possilble in Access 2007?