How do I hide inactive records when creating a report in Acc

[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.

[jbowers66]

Create a query that selects the records you want to print (filters out the inactives) and use that query as the data source for your report.

jb