2012

Fields in Table
Displays a list of available fields from the current database table, from which
you can specify the fields to display in the
Data View window when the query
is executed. If you don't specify any fields to display, the query displays all
fields from the database table. Double-clicking in a field in this list or selecting
a field and choosing Add (Show Fields) adds the field to the list of those that
are displayed in the Data View window by the returned query. You can also
drag fields to add them to the Show Fields and Sort By areas.
Show Fields
Specifies the fields that are displayed in the
Data View window when the query
is executed. To remove a field from this list, drag it from the list to any area
on the Query Builder tab.
Add (Show Fields)
Adds a field to include in the
Data View window display of the returned query.
To add a field, select it in the Fields in Table list window and then choose
Add.
Sort By
Specifies a sort order for the returned query. The first field added to the Sort
By list is the primary sort. To change the sort order for a field, drag the field
to a new location in the Sort By list. By default, fields are added to the Sort
By list in an ascending sort order. To apply a descending sort, select a field and
choose the Ascending/Descending Sort button, or double-click in the field.
To remove a field, drag it from the list to any area on the Query Builder tab
or select the field and press DELETE.
Add (Sort By)
Adds a field to the Sort By list. To add a sort field, select it in the Fields in
Table list window and then choose Add. Repeat for additional fields that you
want to apply to the sort.
Ascending/Descending Sort
Reverses the sort order for the currently selected field. If an ascending sort
order is currently applied, choosing this button reverses the sort to descending
order, and vice versa.
Indicate Records in Data View
Indicates records that match your search criteria in the
Data View window.
Indicate Objects in Drawing
Indicates linked objects that match your search criteria in the current drawing.
Execute
Issues the finished query and closes the dialog box.
474 | Chapter 5 D Commands