Report for Totals for each category

[Khalil Handal]

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

[Welshgasman]

With Google?

https://www.youtube.com/results?sear...+report+totals

[Welshgasman]

With Google?

https://www.youtube.com/results?sear...+report+totals

Also Google crosstab query

https://www.youtube.com/results?sear...otals+crosstab

[Micron]

tblTypes has four fields that shows the type of payment or deduction

That is a design error. There should be one field for types with a record for each type. I suggest you research db normalization and see if you've designed your tables like spreadsheets because it sure seems that way. If you don't fix it, you will continue to have issues.

[Khalil Handal]

Hi,
Thank you for the links provided. I am watching some of the videos.
As for the table tblTypes, I now have it with a primary Key and one field as follows:
pkType, TypeDescription
This table now has four records only with primary keys 1, 2, 3, 4
I will work on my report after these changes and see how it goes.
Thankyou all

Khalil

[Khalil Handal]

Hi,
Thank you all managed to have what I want.