Please am creating a database for a church for payment of tithe. How can i create in such a way that the total amount of payment paid by each member will be allocated to him or her account only.
Please am pleading if someone can be of help.
You need a payments table, with
member_ID, payment_date, amount_paid
the member table sees the records of the payment table via a relationship and can show them in a portal.
A summary (total of) field must exist in the payments table, and it can be displayed on the member layout.
Thank you very much for your help
Am able to do that but how can filter portal by date eg from 2/12/2014 to 4/11/2015
You may want to mark siplus's response as helpful, not your own one ...
Retrieving data ...