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.

I would look at creating a 3rd query that joins/unions the other 2 queries and generate the report from that.

Thanks

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...

Thanks...I am going to spend some time exploring both options. I will let you know what works.

Good luck...