Multiple Print

  • Thread starter Thread starter Karen Howard
  • Start date Start date
K

Karen Howard

Hi,

I have 3 queries in which I have sorted 3 employees names
and their department locations and job duties.

I want to print all 3 queries by only generating ONE
report that combines all the query information but breaks
the report out into 3 so that I don't have to print 3
reports from each employees query.

Can anyone help? Thanks!
 
Hi,

Thank you for using the Microsoft Access Newsgroups.

You wrote:
"I want to print all 3 queries by only generating ONE report that combines
all the query information but breaks the report out into 3 so that I don't
have to print 3 reports from each employees query."

Have you considered using a UNION Query. Example:

<SQL Syntax of 1st Query>
UNION
<SQL Syntax of 2nd Query>
UNION
<SQL Syntax of 3rd Query>

Then base your Report on the above UNION query Grouping By whatever value.

Here's my example using the Customers table in the Northwind sample
database:

SELECT Customers.CustomerID, Customers.ContactTitle
FROM Customers
WHERE (((Customers.ContactTitle)="Owner"))

UNION

SELECT Customers.CustomerID, Customers.ContactTitle
FROM Customers
WHERE (((Customers.ContactTitle)="sales agent"))

UNION

SELECT Customers.CustomerID, Customers.ContactTitle
FROM Customers
WHERE (((Customers.ContactTitle)="Accounting Manager"));


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
 
Back
Top