Merging information into one report

[PMD]

I am trying to create a report from a database designed by someone else. There are multiple linked tables. I have mastered generating either a query or a report using information from these tables but I am having trouble with the following scenario -- A bit of history first...this is a patient care database. The patient medical record number is the link between each table. Each table has a set of fields. One of the tables is labeled "diagnoses". The report I want to generate should list every diagnosis the patient had. When I do a query, each patient has multiple rows with the demographics repeated on each row and then each diagnosis being different. If I do a report, it's multiple pages with the diagnosis being the only thing different per page. How do I get all of this on one sheet?
Since the database is not mine, I cannot change anything in the background or any of the relationships. Thanks for any help you can give - My Access for Dummies book is not doing the trick this time

 

[bluke]

Do you have access to the design of the source query? The join property of the two tables are linked by patient number. Make the join (by double clicking the join line) to option #2 ( Right Join). This gives you all records from diagnosis and only those demographics that match.