SELECT emp_clock.emp_no, emp_clock.emp_dept, emp_clock.clin_date, emp_clock.clin_time, dept_shift_times.work_days.Value, dept_shift_times.shift_type,
IIf((Format([emp_clock].[clin_time],"Short Time")<=Format([dept_shift_times].[clin_to_time],"Short Time")),"On time","Late") AS Attendance...