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

Chapter 7. Sorting, Finding, and Filteri... > Applying Advanced Filters and Sort O...

Applying Advanced Filters and Sort Orders

Filters in Access, as mentioned previously, are queries in disguise, and provide a useful introduction to single-table Access queries, the subject of Chapter 9, “Designing Queries for Jet Databases.” Creating an advanced filter/sort is much like creating a query, with some basic differences, as follows:

  • The Show Table dialog doesn’t appear.

  • The SQL button is missing from the toolbar, so you can’t display the underlying SQL statement.

  • The Show row is missing from the Filter Design grid.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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