fees

[srikanth]

we collect fees in 2 terms. Can I implement this in access. When I select
term1 all the fees pertaining to that should be displayed and the student has
the option of paying in installments too. i.e term1 fees = 5000, he can pay
the same in installments. So when the student pays for the 1st time say 1000
then the balance amount should be shown as 4000 and again when he comes and
pays the remaining balance the balance amount should be zero. If at all any
balances still remain then the same has to be carried forward to the 2nd term.

I also like to generate reports for the following:
1) Balances due
2) Invoice Statement - mailed to the parent
3) Receipts
4) Ledger


Thanking you in advance

 

[DevalilaJohn]

First, please don't multi post, if you ask the quetion once, you will likely
get an answer. If you ask it several times, you may not.

You need to set up several tables. In the simplest version, one will have
students and the other payments. You set up a foreign key relationship
between the student ID in the payments table back to the students table.

The payments table will also have a key on it that will allow you to record
numerous payments per student. With this you can run a query
Select Sum(AmountPaid) from Payments where student = xxxx

This will give you the total paid. From there it is simple arithmetic to
determine if the student still owes anything. The various reports can all be
done from this approach.