Lookin for better way to combine 4 queries

[kentwoodjean]

I have combine 3 queries and get correct numbers. when I add the 4th, it is way out of line. the two common fields on all 4 are Weekending and Ext. Below is the sql for the 3 queries with a seprate SQL for the 4th. Any help is appreciated.
(3 queries)
SELECT ScoreFatiqueWkly.Ext, ScoreIWRtotalWkly.Weekending, ScoreFatiqueWkly.NAME, ScoreIWRtotalWkly.IWRtot, ScoreFatiqueWkly.IWRFat, ScoreNRWkly.IWRnr
FROM (ScoreFatiqueWkly RIGHT JOIN ScoreIWRtotalWkly ON (ScoreFatiqueWkly.Weekending = ScoreIWRtotalWkly.Weekending) AND (ScoreFatiqueWkly.Ext = ScoreIWRtotalWkly.Ext)) LEFT JOIN ScoreNRWkly ON (ScoreIWRtotalWkly.Ext = ScoreNRWkly.Ext) AND (ScoreIWRtotalWkly.Weekending = ScoreNRWkly.Weekending)
GROUP BY ScoreFatiqueWkly.Ext, ScoreIWRtotalWkly.Weekending, ScoreFatiqueWkly.NAME, ScoreIWRtotalWkly.IWRtot, ScoreFatiqueWkly.IWRFat, ScoreNRWkly.IWRnr;

(4th query)

SELECT ToDate-2 AS Weekending, LastName & "," & FirstName AS NAME, Sum(1440*CDate([Duration])) AS IWRpio, tbl_MAIN2071iwrwek.Ext
FROM tbl_MAIN2071iwrwek
WHERE (((IsDate([Duration]))<>False))
GROUP BY tbl_MAIN2071iwrwek.Ext, tbl_MAIN2071iwrwek.ReasonCde, tbl_MAIN2071iwrwek.ToDate, tbl_MAIN2071iwrwek.LastName, tbl_MAIN2071iwrwek.FirstName
HAVING (((tbl_MAIN2071iwrwek.ReasonCde)=0 Or (tbl_MAIN2071iwrwek.ReasonCde)=9 Or (tbl_MAIN2071iwrwek.ReasonCde)=6 Or (tbl_MAIN2071iwrwek.ReasonCde)=19 Or (tbl_MAIN2071iwrwek.ReasonCde)=1001));