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

Case Example

The following case example reviews some of the tools and techniques you learned about in this chapter.

1.
Open the frmCustomers form.
2.
In the State field, select any instance of CA, right-click, and choose Filter by Selection.
3.
Select any instance of Sacramento, right-click, and choose Filter by Selection.
4.
In the ZIP Code field, select 94205, right-click, and choose Filter Excluding Selection.
5.
Choose Records, Filter, Advanced Filter/Sort (see Figure 7.15) to see the criteria you've designated.
Figure 7.15. The design grid shows that the filter has three conditions, all of which must be true at the same time.

6.
Choose Filter, ...

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