Home » Documentation » General Features » Queries » Sort Options

Documentation

Sort Options

copy icon 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.

Last Revision: 07.29.2013
x

Contact

How Can We Help?

Other Ways To Reach Us

Sending your message. Please wait...

Thanks for sending your message! We'll get back to you shortly.

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

x

Add this topic to your list of favorites?