want to only see dates for today and the past

[Guest]

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

 

[Tom Lake]

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

Make the criteria of the date field

<= Date()

Tom Lake