To filter the report content in Access, one way is to develop the report on a query results and every time that you want to filter the report, just modify the query to include the filter criteria in the design view, then save the query, and the record source of the report will be automatically narrow down from the query results. This way has many benefits because you don’t have to create many reports with similar structure and your database looks cleaner. Sometime you do need to frequently produce reports for specific department, region or product. In that case besides the general report, you may want to make a copy of the report and use filter on load option for that specific product or department so you don’t have to go back and forth with the query.
Here is an example.
The report is for all the department, but I need to frequently print for 2 departments, so I put the department_ID in the property for filter. Notice the table name or the query name of the field needs to be filter is referenced as well. Also the Filter On Load property needs to be Yes.
Y. I. An
BI Practice 