Command : Sort…
Keyboard shortcut : Ctrl + T
Icon :
This command classifies the records in the current selection for a given use. Viewing, print, export,…
Note : This command is only active on the list format
Functioning Principal
A sort is always temporary, and therefore not memorised in a permanent way. The sorting order is nevertheless kept until one of the commands are used to modify the current selection or the next sort.
A sort could be:
| · | Increasing (another term ascending): classifying is assigned from A to Z/or 0 to 9.
|
| · | Decreasing (another term descending): classifying is assigned from Z to A/or 9 to 0.
|
You can overlap several sorting standards in an identical or different way.
The points listed below should be taken into account for the sorting execution time:
| · | Sorting done on an indexed field, of the current table, is almost instantaneous, regardless of the number of records contained in the table.
|
| · | Conversely, in case a non indexed field is used, the time is directly dependant on the number of records contained in the current selection.
|
| · | The more fields selected, the longer the execution time will be.
|
| · | The more the field in relation is of a distant relational standard, the longer the execution time will be.
|
Implementation
Certain characteristics of this dialogue are mentioned in the paragraph "Introduction of Standard Dialogue.
The sort dialogue
The sorting characteristics are determined according to the fields placed in the right column. By default, the order of the sorting for a field is increased, and is represented by an arrow pointing up.
To reverse the sorting order on a given field, you just need to click on the arrow which will reverse it.
The modification of a field position, within the 'sorting order' list can be done by using the click and set down technique.
In the example of the dialogue presented below, you obtain your selection of contacts classed in the following manner:
Town A
Contact A
Contact B
…
Contact Z
Town B
Contact A
…
Contact Z
Town …
…
Town Z
Contact A
…
Contact Z
Saving/Opening a format
If your format is liable to be used frequently, you can memorise and store the structure with the help of the Save… button.
If your document is placed in the 'Sort' file, it will automatically be integrated in the '(Open…) list.
Note : Only the structure of your format of sort is saved and the sort selection.