The lower half of the Query Window contains four criteria you can mix and match to determine the order in which records will be displayed on a report or browse. Each of the four is a sort option.
Sorts can have multiple components: a primary sort and secondary sorts, which are separated by a slash (`/’).
If you were running a list of customer invoices from the HISTORY menu, one of your sort options might be ‘COMPANY NAME/DATE’. In this case, the primary sort is by company name and the secondary sort is by date. This means that all invoices will appear in customer name order (the primary sort) but if there is more than one invoice for each customer, those invoices will be sorted by date.
CUSTOMER DATE
JAMESCO 01/16/96
JOHNSON BROS 12/13/95
JOHNSON BROS 01/05/96
JOHNSON BROS 01/18/96
JONES 12/14/95
Again from the HISTORY menu, one of your sort options might be ‘EMPLOYEE/PRODUCT ID/DATE’. In this case, the primary sort is by Employee ID and the secondary sort is by Product ID. This means that all items sold will appear in Employee ID order (the primary sort) but if there is more than one sale of a product per employee, those products will be sorted by Product ID and if there is more than one of the same Product ID for each employee, then those will be sorted by date.
EMPLOYEE PRODUCT DATE
JIM A12367 01/14/96
JIM X98-38902 12/13/95
JOHN A12367 12/29/95
SALLY C95ST56 01/05/96
SALLY C95ST56 01/18/96
SALLY D41004 12/14/95
Like many functions in Simple Accounting, sort options are extendable: If you need data for a report sorted in a particular order not included with your module, call us, we can supply additional Sort Window options to you at a nominal cost.