Report based on 3 Queries

[jabrony76]

Hi all,
I have 3 queries that I would like to base 1 report on. Is this possible?

I have tried to create a report that is not connected via record source to any query or table and then enter in text boxes that have the control source set to the query item that I would like reported and all that shows up is the #Name? error message. I would believe that there has to be a way to do this. Am I wrong? and by the way, it's Access 97. Thanks in advance.
Andy

 

[LarryDeLaruelle]

Andy:

Create a fourth query to bring the results of the first three together (assuming you have a common linking field in each of the three).

Add each field you need for your report and then base the report on that fourth query.

Hope that helps.
Larry De Laruelle
larry1de@yahoo.com

 

[petelyons]

The best way to accomplish this is to make a unique subreport for each of your queries. What I like to do is: create and save a new query file. With the report design view window open, drag & drop the query file into the report design window. Boom! You've now got a subreport in there. Repeat those steps for each query you need in your big report.