multiple queries on a report

[cochise]

How do I include multiple (5+) queries on a single report?
I can get one on, but don't know how to add the others.

 

[RMasters]

Have you tried using sub-reports?

 

[MattRK]

This is a little late, but i would like to know how. Mabey you can explain a sub-report to us. Thanks for any help you can provide.

-Mr.K

 

[WildHare]

A sub report is simply a report embedded in a control on a 'regular' report. Something like a form/subform, but with a report, there is not such a necessity to 'link' the reports together. For example, you may design a new blank report, and simply place the five other reports ON it, as five separate controls, each report totally data-independent. It may make for confusing reading, but I've done similar things in the past, with careful use of section paging and stuff like that. Basically, I needed to print a 10 or 12 page 'report' that was a conglomeration of several others, each one independant, each one starting on a new page.

Try it out by placing TWO subreports on a report, with a page-break control between them, and see how it works - you may have to play around a bit, but you can usually get it to work right.

Jim How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[MikeBronner]

Another, perhaps simpler way, would be to create a query that extracts the necessary fields from your queries you want in the report, then base the report on your just generated query. Seems to work pretty good so far for me.

Cheers ;-)
Mike B. Take Care,
Mike

 

[mward04]

I have had the same problem and I was wondering if the following might work...Rather than selecting a particular table/query go to record source and type: "SELECT * FROM [list all of the tables you want fields from]" then write the query in a text box using the fields you want. I'm going to try this on Monday but if anyone has tried this before and it has worked, please let me know.

Mike