Results of Multiple Queries to one report

[Alan]

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

 

[Allen Browne]

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.

 

[Ted]

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

 

[Duane Hookom]

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;