Urgent Help for SQL Query

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=14036
Printed Date: 29 March 2026 at 7:36pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Urgent Help for SQL Query

Posted By: PrivateEye
Subject: Urgent Help for SQL Query
Date Posted: 28 February 2005 at 9:05am

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.

-------------
The Judgement Day