access.seqlist
Definies collation sequence.
Description
defines Access collation sequence.
The sort(s) invoked by the 'by', 'by-dsnd', 'by-exp', or 'by-exp-dsnd' modifiers a left-to-right order determine the order in which items are processed by Access.
There is no limit to the number of sort keys within an Access report.
The 'by' modifier automatically sorts the specified attribute in ascending sequence, and only applies to the first value in the designated attribute, even if it contains multiple values.
The 'by-dsnd' modifier sorts in descending sequence, and only applies to the first value in the designated attribute, even if it contains multiple values.
The 'by-exp' modifier performs an 'exploded' sort and treats every value in a multi-valued attribute as a separate item for sorting purposes. 'by-exp' sorts in ascending sequence. 'by-exp-dsnd' also treats each every value as a separate item for sorting purposes, but sorts in descending sequence.
Example
sort entity by name name
This example has one sort key. It produces a listing of the entity item-id and
name attribute sorted by the value of the first name in each entity item.
sort entity by state by city by name
This example has three sort keys. First, the data in 'entity' is
sorted by ascending 'state' sequence, and within state by ascending
'city' sequence, and within city by ascending 'name'. The
attributes listed in the file's macro or output-macro are displayed.
sort invoices by-dsnd amount.due
This examples reverses the normal sort order and sorts the highest values to
the top of the list, which is useful for circumstances such as determining who
owes you the most money.
See Also
User Comments
What do you think?
Share your experience or ask a question by using the form below.
Login to leave your comments.