[AccessD] Query, Who didn't attend and in-service

Susan Harkins ssharkins at bellsouth.net
Sat Apr 9 11:49:20 CDT 2005


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.

 





More information about the AccessD mailing list