how to build a report to show multiple queries?

I need to take the data from several queries, and have them all show their
data on one report.

I built a query retrieving data from three other queries, but then if query1
has two records resulting, then my report query duplicates the data from the
remaining queries.. one for each occurance of query1... Obviously, this
won't work.. suggestions?

Separate reports, embedded in Subreport Controls on a "master" report may
address your needs. If the data in the Tables are related, then you should
be able to join them in the Query and not have the problem you describe. If
not, then using Subreport Controls is likely the best approach.

Larry Linson
Microsoft Access MVP

"_Adrian" wrote in message
...
I need to take the data from several queries, and have them all show their
data on one report.

I built a query retrieving data from three other queries, but then if
query1
has two records resulting, then my report query duplicates the data from
the
remaining queries.. one for each occurance of query1... Obviously, this
won't work.. suggestions?

Excellent Larry, I'll look into it!

Hmm... by doing this, I see the results from the subreports on the main
report, but I'm also getting repeated results under each main report
record.. I would expect the subreports to only show their results once!
Any ideas why this might be happening?

Hi Adrian,

I am afraid it's hard to tell without the sample and due to the complexity
of this issue, we are unable to assist with this request in the newsgroups
as the Partner Support newsgroups are geared towards break-fix scenarios.

For further assistance on this issue, please contact Microsoft Product
Support Services by telephone so that a dedicated Support Professional can
assist you further with your request.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default...S;PHONENUMBERS

Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Get Secure! - http://www.microsoft.com/security

This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!