Help with report

[whojstall11]

No, zip both files. Remember to copy and remove/replace confidential data, run Compact & Repair. If the backend is very large because of data, remove records, leave just enough for testing.

to get to the report click on the printer image at the bottom of the pagetest.zip

[June7]

First, why multiple tables for drugs? I would have one table.
Drugs
DrugName
DrugDosage

Cause of data duplication in report is the report RecordSource is a join of General table to 2 tables, to each of which General has 1 to many relationship. Create a MRN section. Put General data in the header and notes data in a subreport in the footer. Medications section isn't really needed. Move that data to Detail section.

The Date field in Notes is labeled as Initial Start Date in the Notes form but you are calling it Discontinue Date in the report. Which is it - start or discontinue?

[whojstall11]

First, why multiple tables for drugs? I would have one table.
Drugs
DrugName
DrugDosage

Cause of data duplication in report is the report RecordSource is a join of General table to 2 tables, to each of which General has 1 to many relationship. Create a MRN section. Put General data in the header and notes data in a subreport in the footer. Medications section isn't really needed. Move that data to Detail section.

The Date field in Notes is labeled as Initial Start Date in the Notes form but you are calling it Discontinue Date in the report. Which is it - start or discontinue?

Ok that didnt work report recordsource joins all the records together. Instead separating my notes table and my current meds table? What do i do next? And for the date field ill fix that later.test_be_Backup.zip

[June7]

I said the problem is that the RecordSource joins table General to two child tables, each with many related records. The implication in my comment was you need to remove Notes from RecordSource query. Then I said to have the Notes records as a subreport. Your report does not show either of these suggestions were implemented, although you did create the MRN group section.

[whojstall11]

I said the problem is that the RecordSource joins table General to two child tables, each with many related records. The implication in my comment was you need to remove Notes from RecordSource query. Then I said to have the Notes records as a subreport. Your report does not show either of these suggestions were implemented, although you did create the MRN group section.

Ok got it to work thank you