two queries inot one report

  • Thread starter Thread starter TY
  • Start date Start date
T

TY

How do I combine two queries into one report? I have a
crosstab query which counts all orders per empolyee and
another query that counts all orders per employee where
service level > 3600. How do I create a report that will
show at least these three columns: "Employee
Name", "Total number of Orders" and "Total number of
Orders where Service Level>3600".
 
Ty,

Create a third query based on the xtab query and the >3600
query. Join these two queries using the employee (or
employee id) field. Double click the join line and select
the "include all rows from xtab and rows from >3600 where
employee is equal" option.

This should return all rows from your crosstab query and
also include fields from the over 3600 query if they are
there. Base you report on this query and see how you go.

HTH,

Terry
 
Back
Top