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

Chapter 33. Working with Records > Adding an Expression to a Filter

Adding an Expression to a Filter

If you simply type text or a number in a cell and click Apply Filter, Access attempts to match the entry you’ve typed. You can also use an expression in a criterion to have Access match a range of values. You can use “or,” “not,” or “in” as part of the expression to further refine the acceptable values. Table 33.1 displays examples of criteria you can use.

To create a filter that uses an expression:

1.
While viewing a form or table, choose Filter from the Records menu, and then choose Advanced Filter/Sort from the Filter submenu.

2.
Use expressions listed in Table 33.1 to add criteria to the filter (Figure 33.20).

Figure 33.20. Apply a filter using an expression.


3.
Click the Apply Filter button to close the Filter window and apply the filter. (Figure 33.21)

Figure 33.21. The records further filtered to include only events between two dates.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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