date queries

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

Guest

I am setting up a training database with multiple training dates where
updated training needs to occur every 3 years.

Two types of training a basic and an update. Everyone must have a basic
training which should be followed up after 3 years with an update and then
further updates every 3 years.

I have set up a table with all the training dates and type of training.

I am having difficulty writing a current query to identify those who are not
up to date with their training. I would appreciate any help
Many thanks


I want to identify who's training is out of date and requires update.
Therefore I want to exclude anyone who has received training within the past
3 years
 
Create a query that identifies everyone that IS up to date on their
training. Save that as qTrainingDone
Now use that in an unmatched query to show those that have not received the
training.

You can probably do this all in one query - depending on your version of
Access. The following generic (I guessed a field and table names) query
should give you the idea.

SELECT PersonTable.*
FROM PersonTable LEFT JOIN
(SELECT T.PersonID
FROM Traiing As T
WHERE T.ClassDate > DateAdd("yyyy",-3,Date())
And T.ClassType = "Accounting") as TR
ON PersonTable.PersonID = TR.PersonID
WHERE TR.PersonId Is Null
 
Back
Top