So what you have there is an Append Query, and you could have things like Indexes preventing you from adding new records.
So, the first step should be just to run the SELECT portion of the query to see if it returns any records. If it does, then the issue is not with the criteria logic, but rather with the Append portion.
Also note that since your criteria is based on the underlying field values, and not the aggregated amounts, you can place them in the WHERE clause instead of the the HAVING clause. It makes it a little more efficient.
So try this:
Code:
SELECT Employees.Clock_Number, Timesheet.OT_Offered, [Employees].[Name_First] & " " & [Employees].[Name_Last] AS Employee_Name, Timesheet.Hours_OT, [Coordinators].[Name_First] & " " & [Coordinators].[Name_Last] AS Coordinator_Name, Timesheet.Period_End
FROM (Employees INNER JOIN Timesheet ON Employees.Employee_ID = Timesheet.Employee_ID) INNER JOIN Coordinators ON Employees.Coordinator_Id = Coordinators.Coordinator_ID
WHERE ((Timesheet.Period_End Between Date()-6 AND Date()) AND (Coordinators.Coordinator_ID=2))
GROUP BY Employees.Clock_Number, Timesheet.OT_Offered, [Employees].[Name_First] & " " & [Employees].[Name_Last], Timesheet.Hours_OT, [Coordinators].[Name_First] & " " & [Coordinators].[Name_Last], Timesheet.Period_End, Coordinators.Coordinator_ID, Timesheet.Period_Start;
Does this SELECT query return any records?