I am using a patient databased designed by someone else. There are multiple tables, each of which are linked by the patient's medical record number. Within each table there are multiple fields. My problem-- I am trying to generate a report which lists all of the diagnoses during the hospital stay (along with demograhic data). Demograhics are one table and diagnoses are another table. When I create a query there are multiple rows for each patient - the demographics are duplicates and the diagnoses are different. If I bring it to a report, it's multiple pages with the diagnosis being different on each page. What I'm trying to do is get it to one page. Thanks for any help. My Access for Dummies is not doing the trick this time.