I need to put the information generated from 3 queries onto one report...
first query contains..
part_id
First_name
Last_name
Gross_Hours
Gross_pay
Home_Dept
Dept_Worked
2nd query contains
Part_ID
Dept_Worked
total of all rev earned by department
3rd Query contains
part_id
Dept of damage
liablity
Need the report to display as follows
Home Dept
Last Name, First Name Part ID
(Department (worked/rev/lia)) Gross Hours Gross Pay Rev lia
across in a line...where ever there is not a value it needs to display a zero amount. so this needs to match by part_id then by depart found for each querie and if there is not a a corresponding match it needs to put a zero where ever need be.
example
sorted by home dept
part_ID 194
dept hours pay rev lia
1100 12 100.00 500.00 0.00
1120 0 0.00 100.00 50.00
1100 60 700.00 0.00 0.00
totals: 72 800.00 600.00 50.00
problem is in it needs to scan all queries by part..then by dept and use all dept enteries from all queries.
ANY IDEAS?
first query contains..
part_id
First_name
Last_name
Gross_Hours
Gross_pay
Home_Dept
Dept_Worked
2nd query contains
Part_ID
Dept_Worked
total of all rev earned by department
3rd Query contains
part_id
Dept of damage
liablity
Need the report to display as follows
Home Dept
Last Name, First Name Part ID
(Department (worked/rev/lia)) Gross Hours Gross Pay Rev lia
across in a line...where ever there is not a value it needs to display a zero amount. so this needs to match by part_id then by depart found for each querie and if there is not a a corresponding match it needs to put a zero where ever need be.
example
sorted by home dept
part_ID 194
dept hours pay rev lia
1100 12 100.00 500.00 0.00
1120 0 0.00 100.00 50.00
1100 60 700.00 0.00 0.00
totals: 72 800.00 600.00 50.00
problem is in it needs to scan all queries by part..then by dept and use all dept enteries from all queries.
ANY IDEAS?
