B
BLM HR guy
I posted this question before but didn't get anywhere with it.
I'm an Access beginner, relatively speaking. I've created a query (and
report) which returns a list of employees, grouped by each
training/certification, with the date the training was completed and a
calculated field that returns when the training expires. (Trainings are taken
individually or by small groups) I was then informed that some of the
trainings are 'higher-level' trainings and satisfy requirements for
completion of lower-level, as do refresher trainings.
The problem: supervisors don't want their folks to show up deficient in any
area unless they're actually deficient (and even then they don’t want it
;-)). How can I structure a query--or queries--to evaluate if a higher-level
course or refresher applies?
Format = **Table Name
Field Name--Type--Primary key or joining field
**tbl_Trainings
Training--Text--Primary key and 1-to-many with tbl_TrainingCrossTable
Renewal_YRS—Number
Level—Number (attempt at establishing hierarchy…set higher number to assign
relative hierarchy w/in a Type…?...)
Type—Text
Refresher—Yes/No
**tbl_TrainingCrossTable
Employee_ID--Number--outer join w/ tbl_Employees
Training--Text--1-to-many join w/ tbl_Trainings
TrainingDate--Date/Time
**tbl_Employees
Employee_ID--AutoNumber--Primary key and outer join w/ tbl_TrainingCrossTable
EmployeeLastName--Text
---A whole lot of unrelated fields used in other applications
Sample data would be
**Employee_ID--Training--Date--Expires
101--First Aid Basics--10/01/2001--[TrainingDate]+365*[Renewal_YRS]
101--First Aid Basics Yearly Refresher--10/01/2006--" ' "
101--First Aid Advanced--10/02/2008--" ' "
I'm an Access beginner, relatively speaking. I've created a query (and
report) which returns a list of employees, grouped by each
training/certification, with the date the training was completed and a
calculated field that returns when the training expires. (Trainings are taken
individually or by small groups) I was then informed that some of the
trainings are 'higher-level' trainings and satisfy requirements for
completion of lower-level, as do refresher trainings.
The problem: supervisors don't want their folks to show up deficient in any
area unless they're actually deficient (and even then they don’t want it
;-)). How can I structure a query--or queries--to evaluate if a higher-level
course or refresher applies?
Format = **Table Name
Field Name--Type--Primary key or joining field
**tbl_Trainings
Training--Text--Primary key and 1-to-many with tbl_TrainingCrossTable
Renewal_YRS—Number
Level—Number (attempt at establishing hierarchy…set higher number to assign
relative hierarchy w/in a Type…?...)
Type—Text
Refresher—Yes/No
**tbl_TrainingCrossTable
Employee_ID--Number--outer join w/ tbl_Employees
Training--Text--1-to-many join w/ tbl_Trainings
TrainingDate--Date/Time
**tbl_Employees
Employee_ID--AutoNumber--Primary key and outer join w/ tbl_TrainingCrossTable
EmployeeLastName--Text
---A whole lot of unrelated fields used in other applications
Sample data would be
**Employee_ID--Training--Date--Expires
101--First Aid Basics--10/01/2001--[TrainingDate]+365*[Renewal_YRS]
101--First Aid Basics Yearly Refresher--10/01/2006--" ' "
101--First Aid Advanced--10/02/2008--" ' "