Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Filters in Reports

Whether or not a filter is applied in a report created from a table or query depends on how the object was created. Try this exercise:

1.	In the Database window, open the tblCustomers table and briefly review the data.
2.	In the State column, select any CA value.
3.	Right-click and choose Filter by Selection.
4.	Close the table and click Yes to save your layout changes.
5.	With tblCustomers selected in the Database window, choose Insert, AutoReport.
6.	Scroll through the report by using the Next Page navigation button. The report has data from both California and non-California companies.
7.	Choose File, Save As; save the report as rptAllCustomers and close it.
8.	Open the tblCustomers table.
9.	Click Apply Filter. Because you saved ...