G
greeneyedladynj
I have a list of employees and several classes that they need to become
recertified for yearly... In the fields I have the due date for their
recerts. Some are due now, some maybe two months ago, and maybe some 9 months
from now. I would like to do a query so that only those dates show up that
are late. So todays date and back. All the future dates I don;t want to show
up. This way my supervisor can let those employees know that they are out of
compliance and need to get recertified. I have fields such as employees
name, (CPR, Medication Training, these are the fields where the dates go)
etc. Thanks!!
Kim
recertified for yearly... In the fields I have the due date for their
recerts. Some are due now, some maybe two months ago, and maybe some 9 months
from now. I would like to do a query so that only those dates show up that
are late. So todays date and back. All the future dates I don;t want to show
up. This way my supervisor can let those employees know that they are out of
compliance and need to get recertified. I have fields such as employees
name, (CPR, Medication Training, these are the fields where the dates go)
etc. Thanks!!
Kim