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

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




More information about the AccessD mailing list