i have two queries I want to join so i can get the percentages from each department of completed work orders but not sure how to go about it. I know i want a join and a crosstab query so i can display the results  in a report.
The first query  calculates the numerator,

SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder, MaximoReport.[Assigned Owner Group]
FROM MaximoReport
WHERE (((MaximoReport.WorkType) In ("PMINS","PMOR","PMPDM","PMREG","PMRT")) AND ((MaximoReport.Status) Like "*COMP") 
AND ((MaximoReport.[Target Start])>=DateAdd("h",-1,[Enter the start date]) 
And (MaximoReport.[Target Start])"00:00") 
AND ((MaximoReport.ActualStartDate)>=DateAdd("h",-11.8,[Enter the start date]) 
And (MaximoReport.ActualStartDate)GROUP BY MaximoReport.[Assigned Owner Group];

while the second query calculates the denominator:

SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder, MaximoReport.[Assigned Owner Group]
FROM MaximoReport
WHERE (((MaximoReport.WorkType) 
In ("PMINS","PMOR","PMPDM","PMREG","PMRT")) 
AND ((MaximoReport.Status)<>"CAN") 
AND ((MaximoReport.[Target Start])>=DateAdd("h",-11.8,[Enter the start date]) 
And (MaximoReport.[Target Start])GROUP BY MaximoReport.[Assigned Owner Group];

please advise how i cann join the two queries to get the percentages of the departments and then do a crosstab query.
If there a better way of doing this please also let me know.

Thought of running the query this way but I get errors.

SELECT SUM(iif((MaximoReport.Status Like "*COMP"),iif((MaximoReport.ActualLaborHours<>"00:00"),1,0),0)) AS CountCompleted,
SUM(iif((MaximoReport.Status) <> "CAN",1,0)) AS CountTotal,
Round([CountCompleted]/[CountTotal]*100,1) AS PercentCompleted
MaximoReport.[Assigned Owner Group]
FROM MaximoReport
WHERE (((MaximoReport.WorkType) In ("PMINS","PMOR","PMPDM","PMREG","PMRT")) 
AND ((MaximoReport.[Target Start])>=DateAdd("h",-1,[Enter the start date]) 
AND (MaximoReport.[Target Start])AND ((MaximoReport.ActualStartDate)>=DateAdd("h",-11.8,[Enter the start date]) 
AND (MaximoReport.ActualStartDate)GROUP BY MaximoReport.[Assigned Owner Group];

---

Reply from Alex Hedley:

UNION Queries can join two datasets.