Comparison or alternative

[Rhea Griffiths]

I am in the process of building a database that tracks all
the training we do. My problem is not the people that get
it, but tracking the people that do not get the various
training that is required. I know what all that training
is for a specific period of time. Additionally people do a
lot of work that is not required, and not all the same
training is required for everyone. This is currently a
very task intensive evolution.
I have been asked to be able to print reports of people
that DONOT have the training. Other than doing it by hand
after I review reports, what can I do?
Thanks,

Rhea

 

[Steve Schapel]

Rhea,

This information is probably obtainable via a very simple query. If
you would care to post back with some details of the structure of your
tables, so we can see how you are presently recording the training
records, someone will be able to give more specific advice.

- Steve Schapel, Microsoft Access MVP

 

[John Vinson]

I am in the process of building a database that tracks all
the training we do. My problem is not the people that get
it, but tracking the people that do not get the various
training that is required. I know what all that training
is for a specific period of time. Additionally people do a
lot of work that is not required, and not all the same
training is required for everyone. This is currently a
very task intensive evolution.
I have been asked to be able to print reports of people
that DONOT have the training. Other than doing it by hand
after I review reports, what can I do?

It should be possible to write a Query which displays those people who
have not received any training, or a Query to display those who
haven't received a particular course. The details of such a Query
depend on your table structure, so I really can't be more specific
without knowing what that structure might be!

What tables do you have in this database, and how are they related?

 

[Rhea Griffiths]

Currently I have a table for the personnel, one for the type of training(category) and then one for the class information that includes the lecture title, date and length of training.

As I mentioned, not everyone is required the same categories, or even lecture titles. Some are based on current job description, others on other requirements I am not exactly free to mention.

Thanks
Rhea