I need an unmatched query to tell me that Employee 1 is missing a timesheet for period 11, subperiod 4; and that Employee 2 is missing a timesheet for period 11, subperiod 3
copy and past this to a new query
Code:
SELECT H.*, *
FROM
(SELECT HR.Employee, [Time Periods].*
FROM HR INNER JOIN [Time Periods] ON HR.[Pay Date] = [Time Periods].[Pay Date]) AS H
LEFT JOIN Timesheets
ON (H.SubPeriod = Timesheets.SubPeriod) AND (H.Period = Timesheets.Period) AND (H.[FY Year] = Timesheets.[FY Year]) AND (H.Employee = Timesheets.Employee)
WHERE (((Timesheets.ID) Is Null))