Training Database

[Glenda]

I have a database with 3 tables - Table A has the employee data (name, id#,
jobtitle, etc.) - Table B has required training (by job title) - Table C has
training history. All tables have an autonumber.

How to create a report by employee that shows a) only the required training
b) something e.g. "NEEDED" if the training has not been completed c) the date
of the training if the training has been completed.

thank you

 

[Jeff Boyce]

Glenda

Are you saying that EVERYTHING on the [Training] table is required, or that
the [Training] table lists {training}, {jobtitle}.

If the latter, you could join your TableA to your TableB on {jobtitle} (?the
same values in both tables?) to get all of the {training} connected with the
{jobtitle} for the Employee.

So, what data are you keeping in TableC? What you mean by "training
history" may not be what I mean. My definition would be something like:

TableC (AKA trelTrainingHistory)
TrainingHistoryID
EmployeeID
TrainingID
TrainingDate

To get at the "still required but not yet taken" training, you could
generate a list of all required training by job title (from TableB), then
compare it to the "taken training" you get from TableC. Where they don't
match up, there's still a "need". You can use the query wizard to help with
the unmatched query.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.