Yhe whole query gets a little long so I think I'll just do the top part:
PARAMETERS [RptDur] Long;
SELECT Att.EmployeeNumber,
Emp.NameFirst, Emp.NameInitial,
Emp.NameLast,
COUNT(Att.EmployeeNumber) AS RecCnt
FROM tblEmployees AS Emp LEFT JOIN tblAttendence AS Att
ON Emp.EmployeeNumber=Att.EmployeeNumber
WHERE ([RptDur]=-14)
And (Emp.EmpStatusType="Active" And
Emp.PayType="per Hour"
And(Att.DateWeekStarting Between Nz([Enter Start Date],DateAdd("ww",[RptDur],Date()))
And Dateadd("ww",(([RptDur]*-1)-1),Nz([Enter Start Date],DateAdd("ww",[RptDur],Date()))))
Of course it does go on but I think that this should give you an idea of where I am trying to eventually go. Thanks the the response.