Join Query Help

[esi]

Running the following query and I'm getting duplicate REGHrs records for
every Department Number and Period. I just need the total REGHrs and OVTHrs
for each Department Number and Period. I know it has something to do with
my query join but, I'm stumped.


SELECT Q1.[Department Number], Q1.Period, qryTotalREGPayroll.Total_REGHrs,
qryTotalOVTPayroll.Total_OVTHrs
FROM (Q1 LEFT JOIN qryTotalREGPayroll ON (Q1.[Department Number] =
qryTotalREGPayroll.Dept) AND (Q1.Period = qryTotalREGPayroll.Period)) LEFT
JOIN qryTotalOVTPayroll ON (Q1.[Department Number] =
qryTotalOVTPayroll.Dept) AND (Q1.Period = qryTotalOVTPayroll.Period)
GROUP BY Q1.[Department Number], Q1.Period, qryTotalREGPayroll.Total_REGHrs,
qryTotalOVTPayroll.Total_OVTHrs
ORDER BY Q1.[Department Number], Q1.Period;