Susan Harkins
ssharkins at bellsouth.net
Sat Apr 9 11:56:45 CDT 2005
So, there is no value for "didn't attend?" Do you leave the field Null (blank)? Or does 2 "on leave" mean "didn't attend"? Susan H. Susan 10 is the courseID and status 1 active 2 on leave 3 terminated Charles Hise This E-mail is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and E-mail confirmation to the sender. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Saturday, April 09, 2005 11:49 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Query, Who didn't attend and in-service What does the id value 10 signify? Also, what do the status values of 1 and 2 represent? Susan H. Access 03. I am trying to develop a query to find distinct employees who did not attend an in-service. The following gives me the employees who did attend; SELECT DISTINCTROW tblEmployee.empID FROM tblEmployee LEFT JOIN (tblCoursesTaught RIGHT JOIN tblEmplTraining ON tblCoursesTaught.ID = tblEmplTraining.tblCoursesTaught_ID) ON tblEmployee.empID = tblEmplTraining.empID WHERE (((tblCoursesTaught.ID)=10) AND ((tblEmployee.status)=1)) OR (((tblCoursesTaught.ID)=10) AND ((tblEmployee.status)=2)); If I use <>10 for tblCoursesTaught.ID, I get the same employees who attended other in-services. I have been working on this for weeks, research, etc. and am lost. I would appreciate any help Charles Hise This E-mail is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and E-mail confirmation to the sender. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com