Printing reports from mutiple queries

[jmriddic]

Hi,

I was wondering if there was a way to print a report containg information from mutiple queries. Basically I want to do a report where I Enter a name in and get a lisitng broken down by drug type for each patient. The information by drug type for the patient is kept in 3 different queries and I have tried a few things to see If i could pull it
but nothing has worked. Each of the queries do have some common fields like Name and Account number. Any help would be appreciated.

 

[Len Boorman]

Couple of things you could try.

Use sub report (just like subform) with master and child fields. So query 1 is the report source, query 2 is the source of report 2 which is a sub report etc.

Or just create the three reports, strip out the header and footers of two and drop them onto the first report without master child linking.

Similar actions and either should work. Just a matter of whether or not the queries have suitable linking fields.

HTH

Len B

 

[jmriddic]

I tried the subreport but after I went through the wizard it gave me a blank section and I know I have a common field between the two. Any suggestions?