cell that you want to group. To insert an end parenthesis, click in the cell
to the right of the last Value cell that you want to group.
Value
Provides a space where you can specify a value for the query condition of
the current row. Click in the Value cell and enter a value, or choose the [...]
button to retrieve a list of available values for the selected field in the
Column Values Dialog Box.
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.
280 | Chapter 6
Summary of Contents for AUTOCAD 2006
Page 1: ...February 2005 AutoCAD 2006 Command Reference ...
Page 24: ......
Page 30: ...6 ...
Page 212: ...188 ...
Page 448: ...424 ...
Page 554: ...530 ...
Page 584: ...560 ...
Page 588: ...564 ...
Page 660: ...636 ...
Page 750: ...726 ...
Page 760: ...736 ...
Page 960: ...936 ...
Page 1194: ...1170 ...
Page 1244: ...Undo Reverses the most recent change made by TRIM 1220 Chapter 21 ...
Page 1310: ...1286 ...
Page 1328: ...1304 ...
Page 1354: ...Zoom Window Zooms to display an area specified by a rectangular window 1330 Chapter 26 ...
Page 1490: ......