O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required