|
|
SELECT a.pid, a.fDay, (a.fTime-w.fTime) AS TotalWrkTime, DatePart('ww',a.fDay) AS WeekGrp, DatePart('w',a.fDay) AS DayGrp FROM atWT AS a INNER JOIN atWT AS w ON (a.pid = w.pid) AND (a.fday = w.fDay) WHERE (((a.punch)<>[w].[punch]) AND ((a.fTime)>[w].[fTime])) ORDER BY a.pid;
