Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

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

Chapter 5. Locating Specific Information > Locating Information that Matches Mu...

Locating Information that Matches Multiple Criteria

Filter By Selection, Filter For <input>, and Filter By Form are quick and easy ways to hone in on the information you need, as long as your filter criteria are fairly simple. But suppose The Garden Company needs to locate all the orders shipped to Midwest states between specific dates by either of two shippers. When you need to search a single table for records that meet multiple criteria or that require complex expressions as criteria, you can use the Advanced Filter/Sort command.


You work with the Advanced Filter/Sort command in the design grid. You can use this design grid to work with only one table.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint