Two querys into one report

[Pusher]

Hi all,
I made a report that is based on a query result. Also i made another query that gets the parameter from the other query thru the report ( [Report]![ReportName]![Fieldname] ). I need this information in that same report. How do i enter the result of this second query into that same report? Is there a way i can make 2 queries into 1 so i don’t need this or is there another way?

Also how do i make a query that gives me results for a number of parameters? For example Device 1 has a number of errors on different location. I made a query that gives me the result of Device 1. There are 5 different devices all with there own number of errors on different location. I want to make a global report where i will have all the devices with all that info.
Thanks

 

[Alansidman]

Two queries can be joined together into a third query so long as there is a common field to join them on. Same as joining two tables to get the result of a query.

You could also create a subreport (similar to a subform) with the recordsource for the subreport the second query. Again you would have to have a common field to create a parent child relationship here.

I am unsure about what you are asking in your second paragraph. Perhaps if you posted an example of what you have and what the expected results you would like, it would be helpful.

Alan

 

[vbaInet]

Double post:

http://www.access-programmers.co.uk/forums/showthread.php?t=221772