• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Find and Filter > Filters in Reports

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 the filter upon exit, you can reapply it upon opening.

10.
On the Table Datasheet toolbar, click the arrow on the New Object drop-down button and choose AutoReport (see Figure 7.3 if you can't find this button).

11.
Scroll through the records. Only those from California are included.

12.
Save the report as rptCaliforniaCustomers and close it.

13.
Click Remove Filter and close the table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint