M
MES via AccessMonster.com
I am trying to figure out how to query and report the following, but I am
having trouble figuring out how to do it.
I have 2 courses that employees can take. The first is a pre-requisite for
the second. Once the first course is taken, the employee has to then take
the second course once a year. I have a table that lists the employee badge
number, course number, and date taken (the primary key is the unique
combination of badge number & course number). From this table I would like
to do the following:
1. Query who has taken the first course in the last year and is coming due
to take the second. (And NOT include those who have taken the first course
and already have taken the second.)
2. Query who has taken the second course and is coming due in the next 60
days to re-take it. (i.e. - date taken+365 <= Date()+60)
3. Report not only who is due to re-take the second course, but also those
who have taken the first course that have not taken the second but are due to.
Can anyone help with this one? Thanks in advance.
having trouble figuring out how to do it.
I have 2 courses that employees can take. The first is a pre-requisite for
the second. Once the first course is taken, the employee has to then take
the second course once a year. I have a table that lists the employee badge
number, course number, and date taken (the primary key is the unique
combination of badge number & course number). From this table I would like
to do the following:
1. Query who has taken the first course in the last year and is coming due
to take the second. (And NOT include those who have taken the first course
and already have taken the second.)
2. Query who has taken the second course and is coming due in the next 60
days to re-take it. (i.e. - date taken+365 <= Date()+60)
3. Report not only who is due to re-take the second course, but also those
who have taken the first course that have not taken the second but are due to.
Can anyone help with this one? Thanks in advance.