How do I hide inactive records when creating a report in Access?

[emily at KU]

I have a database of student employees. A co-worker of mine needs a list of
the employees by room number. I have created a report for her, but I want to
hide the records of inactive employees, and I can't figure out how to do
this. I don't want to delete them from the system, yet I don't want them
showing up in my report.

 

[Allen Browne]

Presumably you have a yes/no field name Inactive in your Employees table?

If so, create a query into the table. Drag the Inactive field into the grid.
In the Criteria row under this field, enter:
False
The query now excludes inactive employees.

Open your report in design view.
Open the Properties box (View menu.)
Set the RecordSource property of the report to the name of this query.

 

[emily at KU]

Thank you SO MUCH. That worked perfectly!

Presumably you have a yes/no field name Inactive in your Employees table?

If so, create a query into the table. Drag the Inactive field into the grid.
In the Criteria row under this field, enter:
False
The query now excludes inactive employees.

Open your report in design view.
Open the Properties box (View menu.)
Set the RecordSource property of the report to the name of this query.