SQLConfigurationSQLConfiguration





Finding, Filtering, Sorting  «Prev 

Filter records using complex criteria

Three sections from the Home tab in the ribbon
Here are three sections from the Home tab in the ribbon (Sort & Filter, Records, and Find). When the Access window is wide, there is plenty of room to show buttons and text (top).
But if you resize the Access window down to a slim the ribbon removes text so it can keep showing the same set of commands.
If you want to know what a no-text button does, hover your cursor over it to see its name.

Location 1 Table pane: In a query multiple tables may appear here. Advanced Filter/Sort allows you to work with only one table.
Location 2 Query by Example (QBE) pane: Use this pane to define your filtered datasheet.
Location 3 Table name and fields: The table that you are filtering appears here with all fields listed. (You may have to use the scrollbar to see them all.)