Results of Multiple Queries to one report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan - 24 Nov 2005 20:33 GMT

I am new to reports and have a db that creates a number of different results
in various queries ... Can I display the results of multiple queries in a
single report ??

Any pointers would be appreciated

Many Thanks

Reply to this Message

Allen Browne - 25 Nov 2005 00:50 GMT

Unless you can UNION the queries together (suitable where they all have the
same number of fields, in the same order, of matching data types), you could
use subreports.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I am new to reports and have a db that creates a number of different
>results
[quoted text clipped - 4 lines]
>
> Many Thanks

Reply to this Message

Ted - 30 Aug 2006 16:52 GMT

I have a simular situation, but not all of the queries have the same number
of fields, int the same order, etc. How can I get this done? The VP that this
is for is starting to breath down my back.

Thanks

> Unless you can UNION the queries together (suitable where they all have the
> same number of fields, in the same order, of matching data types), you could
[quoted text clipped - 8 lines]
> >
> > Many Thanks

Reply to this Message

Duane Hookom - 30 Aug 2006 17:56 GMT

You can easily create blank fields in a union query like:

SELECT FirstName, LastName, Company
FROM tblCompanies
UNION ALL
SELECT FirstName, LastName, Null
FROM tblEmployees;

Signature

Duane Hookom
MS Access MVP

>I have a simular situation, but not all of the queries have the same number
> of fields, int the same order, etc. How can I get this done? The VP that
[quoted text clipped - 18 lines]
>> >
>> > Many Thanks

Reply to this Message