Trouble Making A Report

[Loony22]

Hello, i have trouble making a report.
On each year or period of time the CEO get a report about Patients payment (each payment type is on its own).
In the report, there are as followed:

Headline (payment Type)

Patient ID
Payment for Month and Year (what month and year)
Sum Paid
Comments

I have attached a report in MS Excel. It's an example of how the report should look like.

Few problems needed to be addressed:

1) If for example the patient didn't pay for s specific month, The Report will show that he has 0 sum paid (for the specific month).

2) The user picks his favorite Date Range. For example:
From 01/2001 - 12/2002.


I got these tables for payments.

TblPayment :

PaymentId (TblPaymentForMonth)
PatientID
PaymentType (Ren, economy and etc etc)
SumPaid (Total sum payed)

TblPaymentForMonth :

PaymentForMonthId
PaymentId (related to TblPayment)
MonthId (Related to TblMonth)
Year
SumPayed (Sum payed for the spesific month)

TblMonth :

MonthId (Related to TblPaymentForMonth)
MonthName


I hope someone will help me prepare the report.

 

[DAPPLE]

I looked at your sample, and it's too vague. If you have more details, just didn't send for confidentiality - then good. Now, I'm not a pro at access, but I love excel. What I'd do if I were you is put finishing touches on your spreadsheet. Add columns (total paid, total past due, days past due) all these can be entered as formula's. then when you pull this information in as a table to create your form/report, it will show all information pertaining to ID, regardless if a payment was skipped, so no results will show zero.
hope that helps.