list employees who didn't do training

[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)?

 

[John Vinson]

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)?

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


John W. Vinson[MVP]

 

[Guest]

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

John W. Vinson[MVP]
My Table structure:

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

 

[John Vinson]

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#?

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]

 

[Guest]

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#?

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

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

 

[John Vinson]

Table 1: name, termination date "Is Null" because I only want to query
current employees

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?

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?

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?

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]