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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Thank you SO MUCH. That worked perfectly!

Allen Browne said:
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.
Click to expand...
 
Back
Top