I am working on a kind of attendance system using MS Access
2000, Visual Basic 6.0 and Crystal Reports 9. My database tables are as under:
tblDepartment
Dept_ID, Dept_name
tblEmployees
Emp_ID, Dept_ID, Emp_name, Designation
tblAttendance
Attendance_ID, Emp_ID, In_Time, Out_Time, Leave_Type,
Date_Stamp
I need help for SQL Query to generate following reports:
Report 1 Absent Report
Report for Employees who are absent today. Employees whose
In_Time, Out_Time and Leaves
(Leave_Type) is NULL are considered as Absent.
Report 2 Time Report
I need query for this report so that I can display
Emp_ID, Emp_name, Dept_name, Designation, In_Time, Out_Time for all employees
for Current Date including those employees for whom Leave_Type = ‘Short Leave’
Please help. Thanx.
Edited by PrivateEye - 28 February 2005 at 2:55pm
Topic Options
Post Options
Thanks(0)
