Filtering and Sorting Table Data

Sort or filter the data displayed in the Referenced Tables view and in the Table Data Editor.

Filtering and sorting criteria apply only to the environment where you enter them. For example, if you sort a table by city in Referenced Tables and open that table (or have it open already) in Table Data Editor, the sort by city does not affect the display.

Double-click a table in the Referenced Tables view.
The Table Data Filter opens.

Specify filtering options.

Filtering option	Do this
Columns	Select the columns that you want to display. Use Select All, Deselect All, and Invert Selection to respectively display all columns, no columns, or the inverse of the selected columns.
Where clause	Click Where and enter a where clause, if desired.
Order by clause	Click Order by and enter an order by clause, if desired.

You must enter the where or order by clause manually. If you get the error Column 'value' not found, be sure you entered the selection criteria correctly, enclosing character data in single quotes.

Click OK.