Serious Query

[RLUnderwood]

I have been trying to figure this query out and i just can't seem to make it work - advice ?

I have a DB with several related tables:
- people (their position is a field)
- position
- training courses
- required training (training courses by position)
- completed training (training courses by person)

I want to produce a query that will give me the required training (by course and person) that has not been completed.

I have several attempted starts but nothing even close to show as an example - any suggestions (besides doing in manually) ???


SOLVED

SELECT [Training Required by Person - Not Trained].TngReq, [Training Required by Person - Not Trained].Course, [Training Required by Person - Not Trained].[Course Name], [Training Required by Person - Not Trained].[ID], [Training Required by Person - Not Trained].[Last Name], [Training Required by Person - Not Trained].[First Name]
FROM [Training Required by Person - Not Trained]
WHERE ((([Training Required by Person - Not Trained].TngReq) Not In (SELECT TngCmp FROM [Training Completed by Person - Not Trained])));