Use DateValue to get the Date part of your clock in/out, then filter by that date, or between that date-7 and that date, whatever you want to use for a time frame.

Dim X
X=DateValue(ClockIn)

You could use the same setup to limit a reports results to print.

If you really need somebody else to physically do the work, you could post over in the Access DevNet

I think DateValue and TimeValue are both covered in .Access Expert 28 which you have.

Thanks for pointing me in the right direction I will look into this and see what I can figure out.