list employees who didn't do training

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a list of employees who didn't do a specific training? What
expression do I use in the criteria field. Does it matter what field I use
(ID#, name of training, date of training)?
 
How do I create a list of employees who didn't do a specific training? What
expression do I use in the criteria field. Does it matter what field I use
(ID#, name of training, date of training)?
Click to expand...

Care to share your table structure? You can see it; we cannot. How are
you recording training?


John W. Vinson[MVP]
 
John Vinson said:
Care to share your table structure? You can see it; we cannot. How are
you recording training?
Click to expand...
John W. Vinson[MVP]
My Table structure:
Click to expand...
Table 1 is demographic info, such as name, position, etc
Table 2 is inservice info, such as inservice name, inservice date, employee
ID#, etc

How do I query employees who didn't do a specific inservice using inservice
ID#?
Steve
 
Table 1 is demographic info, such as name, position, etc
Table 2 is inservice info, such as inservice name, inservice date, employee
ID#, etc

How do I query employees who didn't do a specific inservice using inservice
ID#?
Click to expand...

A Subquery:

SELECT [Table 1].*
FROM [Table 1]
WHERE [ID#] NOT IN
(SELECT [ID#] FROM Inservice
WHERE InserviceName = [Enter service name:])

John W. Vinson[MVP]
 
John Vinson said:
Table 1 is demographic info, such as name, position, etc
Table 2 is inservice info, such as inservice name, inservice date, employee
ID#, etc

How do I query employees who didn't do a specific inservice using inservice
ID#?
Click to expand...

A Subquery:

SELECT [Table 1].*
FROM [Table 1]
WHERE [ID#] NOT IN
(SELECT [ID#] FROM Inservice
WHERE InserviceName = [Enter service name:])

John W. Vinson[MVP]
thanks, but I'm still unable to do query
Click to expand...
Table 1: name, termination date "Is Null" because I only want to query
current employees
Table 2: employeeID, dateofinservice, inserviceIDNumber
Table 3: InserviceIdNumber, InserviceName
In your subquery of table 1:
WHERE [ID#] Not in - Is this employeeID?
SELECT [ID#] FROM Inservice - How do I do this?
WHERE InserviceName = [Enter service name:]) - This is in table 3. I entered
(InserviceName = [mandatories:]). Is this correct syntax? Why did Enter
Parameters box pop up?
thanks,
steve
 
Table 1: name, termination date "Is Null" because I only want to query
current employees
Click to expand...

Fine. You didn't mention that; and my telepathy was not working
correctly.
Table 2: employeeID, dateofinservice, inserviceIDNumber
Table 3: InserviceIdNumber, InserviceName
In your subquery of table 1:
WHERE [ID#] Not in - Is this employeeID?
Click to expand...

I was using the fieldname from your post. Again... YOU can see your
database; you know your fieldnames; I do not.
SELECT [ID#] FROM Inservice - How do I do this?
Click to expand...

By selecting the correct fieldname and tablename - which you know, and
which I do not.
WHERE InserviceName = [Enter service name:]) - This is in table 3. I entered
(InserviceName = [mandatories:]). Is this correct syntax? Why did Enter
Parameters box pop up?
Click to expand...

Presumably because you put in brackets some name which Access does not
recognize as a fieldname.

Could you please post the SQL view of the query? What I posted was a
SUGGESTION, for you to adapt, not a final solution!


John W. Vinson[MVP]
 
Back
Top