A single INFO/ACCESS query may specify multiple attributes to be sorted. These specifications are processed from left to right. For example:
|
>SORT CUSTOMERS BY STATE BY LAST-NAME BY FIRST-NAME STATE LAST-NAME FIRST-NAME |
The following report example displays all items in the CUSTOMERS file sorted by state. Within each state grouping, items are sorted by the customers’ last names, and within each last name grouping, items are sorted by first name.
|
PAGE 1 |
|
10:57:31 DD MMMM YYYY |
|
|
|
|
|
|
|
CUSTOMERS... |
State... |
Last Name... |
First Name |
|
|
|
|
|
|
AORLA5993 |
CA |
ORLANDO |
AMY |
|
JPEER5993 |
CA |
PEERCE |
JAN |
|
DEDGE6635 |
FL |
EDGECOMB |
DAVID |
|
MASHX5777 |
IN |
ASH |
MARY |
|
JBUCK6488 |
IN |
BUCKLER |
JULIE |
|
HJENK7129 |
IN |
JENKINS |
HAROLD |
|
JMASO6378 |
IN |
MASON |
JULIA |
|
AJOHN5396 |
KY |
JOHNSON |
ANNE |
|
JBOHA5422 |
MA |
BOHANNON |
JOHN |
|
JBROW6749 |
MA |
BROWN |
JAMES |
|
AEDWA5224 |
MA |
EDWARDS |
ANTHONY |
|
BLAMP6196 |
MA |
LAMPSON |
BOB |
|
BLEAR6803 |
MA |
LEARY |
BILL |
|
AMEAD5619 |
MA |
MEADE |
ANDREW |
|
HHIGG6849 |
NB |
HIGGINS |
HENRY |
|
HJOHN7265 |
NB |
JOHNSON |
HENRY |
|
SPIRS5289 |
NC |
PIRS |
SANDRA |
|
RPIER5539 |
NJ |
PIERCE |
RICK |
|
|
|
|
|
|
18 ITEMS LISTED. |
|
|
|
See Also