Nov 7 2005, 12:02 PM
I am trying to create a report that uses data from two queries. The queries work great on their own, but, when I try to combine the data on one query the data is changed. One query is pulling AveragesByMonth while the other is pulling StDevByMonth. How can I get these two queries to work together? Please help.
Edited by: PAYH on Mon Nov 7 12:04:25 EST 2005.
Nov 7 2005, 12:21 PM
I would look at creating a 3rd query that joins/unions the other 2 queries and generate the report from that.
Nov 7 2005, 12:31 PM
If the data is really not related, then a union query will not work and they can not be combined onto a single query..
I would use a report for the first query and sub report for the second one, or a report with two subreports, one for each query.
Hope this helps...
Nov 7 2005, 12:36 PM
Thanks...I am going to spend some time exploring both options. I will let you know what works.
Nov 7 2005, 01:09 PM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here