Filter not flowing through to Report

[JMD]

I have filtered my table, but the filtered data is not flowing through to my
report. i.e. when employees are purged from our roles, I have a inactive
yes/no field. I've filtered out the inactive. However, all the employees are
showing up on the report. Any help would be greatly appreciated.

 

[Allen Browne]

Create a query taht selects all the fields from your employees table.
In the Criteria row under your Inactive field, enter:
False
Save the query.

Now set the RecordSource of your report to this query.

As you found, a filter you apply in a table does not apply to a form or
report, so use the query.