I need your help.
I have created a simple database in Access which accepts students' records including fees. I have 2 tables: one for the students records and the other for the fees.
My problem is what must I do so that if a continuous student pays a fee for the sencod year, I will be able to create a report so that the new fee would reflect on the report? I want something like this:
Total fee: 1,000.00
Total payment: 900.00