I am using code found within this group. It utilizes the DateAdd
function.
This is the query:
SELECT DateAdd("d",-Weekday([ClockInDate]),[ClockInDate])+1 AS WeekOf,
TimeClockHistory.Employee
FROM TimeClockHistory
GROUP BY DateAdd("d",-Weekday([ClockInDate]),[ClockInDate])+1,
TimeClockHistory.Employee;
Ultimatly, when this is run, it generates a report with Clock In and
Clock out times, per day in a new column.
Works Great!
However, is there a way I can filter this to specific dates? If have
found that by changing "ClockInDate" to "[Date1], this allows the user
to specify one week. I want them to be able to specify 2 weeks..
Any suggestions? I can clarify more if need be.
Thank you!
~Drum2001