Required Tables

[Fandy]

This will sum by day by each student fees due by fee type
SELECT fees.feesdate, fees.student_id, fees.feetype, Sum(fees.feeamount) AS SumOffeeamount
FROM fees
GROUP BY fees.feesdate, fees.student_id, fees.feetype;


For this you have to add student_id field in your payment table, then create a relationship between it and the fees table, though i still have a feeling your database is still not well structured.

Please can you help me structure my tables well so i can proceed with my project?
I really help you help and support. I would not mind if i have to start from scratch please

 

[Fandy]

Please can you help me structure my tables well so i can proceed with my project?
I really help you help and support. I would not mind if i have to start from scratch please

Please can you help me structure my tables well so i can proceed with my project?
I really need your help and support. I would not mind if i have to start from scratch please

 

[oleronesoftwares]

Please can you help me structure my tables well so i can proceed with my project?
I really need your help and support. I would not mind if i have to start from scratch please

Send in a copy of your file, without data in a zipped folder, if you don't mind waiting a few days, I can help look into it.

 

[Fandy]

Send in a copy of your file, without data in a zipped folder, if you don't mind waiting a few days, I can help look into it.

Please attached is the zip file per your request.
Thanks so much and hope to hearing from you
soon.

 

[oleronesoftwares]

Please attached is the zip file per your request.
Thanks so much and hope to hearing from you
soon.

Hi,
I have created a table that has the name StudentTransactionsT and a report, study the structure and data of the table, also open the form called StudentTransactionsT to see the sample data.

The sample report shows data of one student showing fees due, fees paid, and outstanding per quarter.

 

[arnelgp]

i also made a sample (without any report yet).
you need to complete the Enrollee list and their Fees.