Hi,
I have tblNames, tblPayments, tblDeductions, tblTypes. The tblTypes has four fields that shows the type of payment or deduction (example: Elecricity, Water, Rent, Tution).
I want to buld a report that shows the total of payments for each type (category) that each person payed.
Example:
Name Total of Electricity Total of Tuition ....Total Deduction
Tom 540 250 120
Note: For each payment the type of payment must be selected.
How can this be done?
Khalil