U.M. (Windows)

4-30 FileMaker Pro User’s Guide
3. In the Sort Records dialog box, choose fields for sorting, in the order
you want them sorted.
To Do this
Choose a sort field and sort it
according to the selected order
In the fields list, double-click a field.
Assign different sort orders to
fields as you add them to the
Sort Order list
For each sort field, in the fields list, select a field, select
a sort order, and then click Move.
Ascending order is first to last character in the alphabet
for text, lowest to highest for numbers, and earliest to
latest for dates and times. Descending order is last to
first character in the alphabet for text, highest to lowest
for numbers, and latest to earliest for dates and times.
Change the sort order for fields
in the Sort Order list
For Sort Order, select a field, and then select a sort order.
Sort according to the order of
values in a value list (for
example, in the order months
are arranged)
In the fields list, select a field, select Custom order based
on value list, and then choose or define a value list. (See
“Defining value lists” on page 3-74 and “Entering data
from a value list” on page 4-9.)
Change the order of fields in
the Sort Order list
For Sort Order, use the double-arrow (to the left of the
field name) to drag the field to a new position.
Remove a field from the Sort
Order list
For Sort Order, double-click the field.
Remove all fields from the Sort
Order list
Click Clear All.
Sort by summary fields Select Include summary fields. (See “Sorting by summary
fields” on page 4-32.)
Use a language for the order in
which fields are sorted that’s
different from the one used
for indexing
Select Override field’s language for sort, and then choose
a language.
Close the Sort Records dialog
box without sorting
Click Done.