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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"emily at KU" emily at wrote in message
...
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.

Thank you SO MUCH. That worked perfectly!

"Allen Browne" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"emily at KU" emily at wrote in message
...
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.