All the info is included for anyone who can help me. Thanks.

[lactbc]

1st table is Patient with; Pat#,name,healthcenter,DOB
2nd table is Treatment with; Pat#,DateTreat,drug1,drug2
3rd table is Laboratory with; Pat#,DateLab,Labname,Labtest

Tables 2 and 3 are linked to table 1 by Pat#. One to many relationship.


I want my Report to look like this:

HEADER: The Patient Table 1 is the header that repeats on every page for that patient name and patient#

BODY: The body is Treatment Table 2 listing all the dates and drugs the patient took; i.e.
DateTreat Drug1 Drug 2
1/1/05 Paxil Zoloft
2/1/05 Paxil Zoloft
3/1/05 Paxil Zoloft

If the list is long, it should spill to the next page. I want to permanently sort the DateTreat field.

FOOTER: The footer is the 3rd Table Laboratory on its own listing the Lab variable. I want to permanently sort the DateLab field.

I can’t seem to get it right. Should this be easy or hard?

 

[dhookom]

The 3rd table should be the record source of a subreport. You can place the lab subreport in the Pat# group footer section and set the Link Master/Child properties to Pat#.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]