Database report

Closed
chitrachit Posts 2 Registration date Thursday December 24, 2015 Status Member Last seen December 24, 2015 - Dec 24, 2015 at 12:04 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 25, 2015 at 11:42 AM
Dear Sir

I have the following fields
Month Receipt No Ref No. Name of the student Fees Transport Total. We enter the data according to the receipt No that is amount collected from each student. I want how much amount has been collected from each student in table format. So that outstanding amount can be easily taken. Kindly help to create

thanks in advance

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 25, 2015 at 11:42 AM
so potentially you would have two rows for a student with two receipt number(lets say one for transport and one for fee)
0