Results of Multiple Queries to one report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
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;
 
Back
Top