I would like to set up a report that would help to show the following: My employees have certain criteria to meet before the end of their probationary period and that information needs to be updated periodically, ie. copy of their driver's license, ins. etc..  I currently have a report which shows all of the employment requirements.  This information is stored in a table named Emp Requirements.  access to this is by a sub-form off the main employee form.This data is stored in the form of date fields and yes/no check boxes.  I need to set up a report that will show me only the items that haven't been checked off as satisfied and those items which are out of date. Any EASY suggestions, if not easy, any suggestions would be appreciated.

I would like to set up a report that would help to show the following: My employees have certain criteria to meet before the end of their probationary period and that information needs to be updated periodically, ie. copy of their driver's license, ins. etc..  I currently have a report which shows all of the employment requirements. This information is stored in a table named Emp Requirements.  access to this is by a sub-form off the main employee form.This data is stored in the form of date fields and yes/no check boxes.  I need to set up a report that will show me only the items that haven't been checked off as satisfied and those items which are out of date. Any EASY suggestions, if not easy, any suggestions would be appreciated. Use a query as the report recordsource. As criteria for the Check box field, write: 0 As far as criteria for out of date items, when is an item out of date? What ever that answer is, use it as criteria in the Date Field.

can the date for overdue items be entered in the criteria area as today() or date() so that it will be up to date as of whenever the report is opened.? Please include the relevant part of any previous post. It makes keeping track of replies easier. Others who may be reading this post haven't a clue as to what you are referring to. Without seeing your data, I guess that entering < Date() in the DateField's criteria line is what you are looking for,

Use a query as the report recordsource. As criteria for the Check box field, write: 0 I set up a query with the proper fields for the report. I put a 0(zero) in the criteria area for all yes/no check box fields(data type) As far as criteria for out of date items, when is an item out of date? What ever that answer is, use it as criteria in the Date Field. in the criteria for the date fields is put <Date() This creates an empty query.  I attached it to the existing report and all the check boxes were darkened in. Help, what did I do wrong!  

Use a query as the report recordsource. As criteria for the Check box field, write: 0 I set up a query with the proper fields for the report. I put a 0(zero) in the criteria area for all yes/no check box fields(data type) As far as criteria for out of date items, when is an item out of date? What ever that answer is, use it as criteria in the Date Field. in the criteria for the date fields is put <Date() This creates an empty query.  I attached it to the existing report and all the check boxes were darkened in. Help, what did I do wrong!   You probably didn't place the date criteria on the line below the check box criteria. The Query SQL Where clause should read: Where [CheckBox] = 0 OR DateField < Date() Check the SQL by clicking on the View Tool button and then on SQL. If you want to, reply to this post by copying and pasting into a Reply to this message the actual SQL used in the query.