How to hide "Inactive" employees

[Dave]

Access 2003 and Access 2007

I have a table of Company Employees

I have added a field (yes/No) to the table called inactive.

I have several reports that list employees. Now I want to NOT SHOW employees
(on those reports) if the "Inactive" check box is checked Yes.

I assume this will be some sort of if statement that will test if that field
is "True" but beyond that I am not even sure if I put this code on the open
event of each report or in the report Query for each report?

Some quidance on both the code and the location of the code will be
appreciated.

thanks

dave

 

[fredg]

Access 2003 and Access 2007

I have a table of Company Employees

I have added a field (yes/No) to the table called inactive.

I have several reports that list employees. Now I want to NOT SHOW employees
(on those reports) if the "Inactive" check box is checked Yes.

I assume this will be some sort of if statement that will test if that field
is "True" but beyond that I am not even sure if I put this code on the open
event of each report or in the report Query for each report?

Some quidance on both the code and the location of the code will be
appreciated.

thanks

dave

A check mark indicates the employee is inactive.
You do NOT wish to show Inactive employees.

If so, just add the Inactive field to the query (if it's not already
included). As criteria on this Inactive field write
No
(Note there are NO quotation marks around the word No)
Only Active employees will be shown.

To show Inactive employees, change the criteria to
Yes