Filter & Sort - Sort tab

Sorting organises a report, list or lookup table. You can insert or delete sort fields, re-order fields, or erase all Sort fields.

Add sort criteria by selecting a field from the Field Name drop-down. When more than one sort field is specified, the records are first sorted by the field at the top of the list. If this does not sort the records (because more than one record has the same data), the second field on the list is used. For example, you can sort Customers by City (Address Line 3), then by Sales Year to Date within each city.

You can also sort data in a Grid List directly,

click the title bar of a field in a grid to sort the items by that field, a small grey arrow appears in the title bar of the selected field, indicating the order of the sort,
click again reverse the order (ascending or descending),
click again to clear sorting and return to the default order,
or click the title bar of another field to change the sort criteria.

See also Filter & Sort.


Field Name		The drop-down contains all the fields in the data file available for sorting.
Descending		Selected, sort will be descending. Clear, sort will be ascending, alphabetically from A-Z for string fields; numerically from the lowest negative to the highest positive figure for number fields; and from oldest to most recent for date fields.
Toolbar
	Expand Toolbar `(Ctrl+F9)`	Expand the toolbar to give access to all toolbar options. Press `Esc` to close the expanded toolbar.
	Insert `(F4)`	Insert an item at the selected line.
	Move `(Shift+Up) (Shift+ Down)`	Select an item and move it higher or lower on the list.
	Delete `(F3)`	Delete the selected item.
	Clear Filter `(Ctrl+F3)`	Clear the selected sort criteria.