G
Guest
I was wondering if someone could give me a bump in the right direction. We
have a database with all our employees in it and also all of their trainings,
write-ups, etc. Our employees can lose a portion of their raise if they have
a mark in 1 of 3 categories, Trainings, med errors, or Performance
Improvement Discussions (PID). Currently I have queries that will pull up if
anyone has a late marke, one for those who are missing trainings, one that
counts the number of PID's and one that counts the number of Med errors.
I would like to be able to set up a report that will put the employees name,
and then list what they have late or a mark in, and automatically do this for
each employee but kind of need a bump in the right direction as to where to
start. The PID and Med query both have date parameters that one enters. The
training queries just generate when selected. If more info is needed, let me
know since I know this is a vague description.
Thanks
have a database with all our employees in it and also all of their trainings,
write-ups, etc. Our employees can lose a portion of their raise if they have
a mark in 1 of 3 categories, Trainings, med errors, or Performance
Improvement Discussions (PID). Currently I have queries that will pull up if
anyone has a late marke, one for those who are missing trainings, one that
counts the number of PID's and one that counts the number of Med errors.
I would like to be able to set up a report that will put the employees name,
and then list what they have late or a mark in, and automatically do this for
each employee but kind of need a bump in the right direction as to where to
start. The PID and Med query both have date parameters that one enters. The
training queries just generate when selected. If more info is needed, let me
know since I know this is a vague description.
Thanks